I want to insert multiple rows in a table in one single query. Insert query is working when i have to insert single row but when it comes to insert multiple rows its taking the value of last rows...
this is the query i am using
INSERT INTO [table]
( [field1], [field2], [field3] ) VALUES
( '[value1.1]', '[value1.2]', '[value1.3]' ),
( '[value2.1]', '[value2.2]', '[value2.3]' ),
( '[value3.1]', '[value3.2]', '[value3.3]' ),
Any suggestions
How to insert multiple rows in one single query??
Moderator: General Moderators
-
shubham.amola
- Forum Newbie
- Posts: 8
- Joined: Mon Jan 19, 2009 11:57 pm
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey