hai! Can i insert 2 records by using a single insert query??

hai! Can i insert 2 records by using a single insert query in MYSQL??
if so explain please

 

Not that I know of.

My knowledge is limited to Oracle, MS Access, MYSQL and some SQL Server.

Never heard of this possibility. (In my openion it is not possible)

Thanks

 

Something like this?

insert into test (id,name) values (1,'XXX'),(2,'YYY');

 

Yes you can..

But if you do you have a problem:

* For large inserts you won't be able to backup or restore such database. Even SSH won't take the overload.

I was trying a 150 MB file on a 1 GB ram / 100 GB hd / 3.0 GHZ and it wouldn't take it. I had to read the file bits by bits and rebuild the queries.

Peace,

 

AS i ksnow it is not possible you should do it whith different INSERT-s!!!

 

IT IS VERY possible as stated above. You simply need a comma between each record

mysql_query("INSERT INTO (column1, column2 column3) VALUES ('val1','val2','val3'), ('val4','val5',val6')");


Produces results:

column1  |  column2  |  column3
-------------------------------
val1         val2         val3
val4         val5         val6

PHP:

This works on all database types, MYSQL, ORACLE, SQL SERVER.