INSERT ALL INTO equivalent...

INSERT ALL INTO equivalent...

El Forum
Guest

09-17-2008, 10:11 PM

[eluser]chandrajatnika[/eluser]

Code:
INSERT INTO yourtable(field1,field2) VALUES('$field1_value1','$field2_value1'),('$field1_value2','$field2_value2'),('$field1_value3','$field2_value3'),('$field1_value4','$field2_value4');

after your execute this query, then 4 rows will affected

Messages In This Thread

INSERT ALL INTO equivalent... - by El Forum - 09-17-2008, 02:11 AM

INSERT ALL INTO equivalent... - by El Forum - 09-17-2008, 09:11 AM

INSERT ALL INTO equivalent... - by El Forum - 09-17-2008, 10:39 AM

INSERT ALL INTO equivalent... - by El Forum - 09-17-2008, 10:11 PM

INSERT ALL INTO equivalent... - by El Forum - 09-17-2008, 11:20 PM

INSERT ALL INTO equivalent... - by El Forum - 09-17-2008, 11:29 PM

INSERT ALL INTO equivalent... - by El Forum - 09-17-2008, 11:45 PM