how can i insert data into two table
habib rahman
0
Newbie Poster
Recommended Answers
Jump to Postwith two insert statements.
All 3 Replies
ryantroop
177
Practically a Master Poster
with two insert statements.
UK-1991
0
Posting Whiz
Hello,
Try This SQL query to insert data in 2 different tables at a time
insert into Table1 (Column1, Column2, Column3)
values ('column_value1','column_value2','column_value3')
insert into Table2 (Column1, Column2, Column3)
values ('column_value1','column_value2','column_value3');
lps
71
Posting Pro in Training
Maybe you can refer this: http://stackoverflow.com/questions/3860280/sql-insert-into-multiple-tables-in-one-query
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.