excute INSERT query faster

[phpsnook]

hai

when the no of columns is 10 rows to be more than 2000 ....which type of insert is best??

INSERT INTO example (name, age) VALUES('Timmy Mellowman', '23' );

or

INSERT INTO example (name, age) VALUES('Timmy Mellowman', '23' ),('jimmy','16' ),(' johnn', '19' );

[Shanti C]

As i know Use multiple-row INSERT statements to store many rows with one mysQL statement is the best.....

For more information visit this...

[phpsnook]

i have a .sql file with an insert statement having more than 1000 records .............the server always says Server gone away.............how do i do it???