Is it possible to insert data into multiple tables with a single sql statement? | Sololearn: Learn to code for FREE!
Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren
+ 2

Is it possible to insert data into multiple tables with a single sql statement?

30th Aug 2018, 7:24 AM
Caleb Tweneboah
Caleb Tweneboah - avatar
3 Antworten
+ 1
Thanks guys I'll just split my form up and write different statements for each one.
30th Aug 2018, 12:50 PM
Caleb Tweneboah
Caleb Tweneboah - avatar
0
No it isn't possible, but you can use transactions
30th Aug 2018, 7:44 AM
Nifriz
Nifriz - avatar
0
IMPOSSIBLE !!! You can not insert values in two tables simultaneously using one query, better try double insert query.
30th Aug 2018, 8:41 AM
Abram Mokgethi
Abram Mokgethi - avatar