Trying to at 900 entries to a table

I am new to mysql and I am trying to add 900 entries to a table all at one. One at a time is just to much pain. How can I accomplish this? Thanks

 

you can insert multiple records with a single INSERT query e.g.

INSERT INTO table_name (column1, column2)
VALUES ('val1', 'val2'), ('val11', 'val22'), ('val111', 'val222');

 

or use a gui -
try: http://dev.mysql.com/downloads/gui-tools/5.0.html

are these 900 data sets raw data or do you have a csv excel ... file?

 

I have a csv excel

 

Ok you can use some GUI tool such as MySQL admin or Navicat to do it. There is a facility called import excell data in both GUI tools.

 

Just used the insert into command after I created the data set and all worked fine. Thanks for all the support.