Thread: insert multiple rows in database
View Single Post
•
•
Join Date: Oct 2005
Posts: 4
Reputation: sweetyp is an unknown quantity at this point 
Solved Threads: 0
sweetyp sweetyp is offline Offline
Newbie Poster

insert multiple rows in database

 
0
  #1
Oct 26th, 2005
How do i insert multiple rows in database.
for example: I have 3 list:
list1: a1,a2,a3,a4
list2: b1,b2,b3,b4
list3: c1,c2,c3,c4

I want to insert a1,b1,c1 in 1st row. a2,b2,c2 in 2nd row,...
How do I write one sql insert statement to do that?
Reply With Quote