need a way to import a large amount of data into MySQL database

Question

I want to insert a LARGE number of rows like this:

INSERT INTO All (ID, number) VALUES ('90001', '1');

and 90001 keeps increasing for each row. is there some way to do whis without using that command once for each row?

I'm currently using phpMyAdmin and Microsoft Excell to generate the commands for the next 10,000 rows each time.

user447688 · Accepted Answer · 2009-06-10 11:47:11Z

1

LOAD DATA INFILE?

answered Jun 10, 2009 at 11:47

user447688

Sign up to request clarification or add additional context in comments.

1 Comment

Hintswen Over a year ago

doesn't help me... that's just as bad as me pasting the commands in. I need a loop so I can tell it what to start/finish at and let it to the rest... not make me generate a list of commands then upload it.

Ben Hammond · Accepted Answer · 2009-06-10 11:42:25Z

0

have a look at [http://dev.mysql.com/doc/refman/5.0/en/loop-statement.html 1

see if that gives you any pointers

answered Jun 10, 2009 at 11:42

Ben Hammond

7251 gold badge7 silver badges20 bronze badges

Collectives™ on Stack Overflow

need a way to import a large amount of data into MySQL database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related