如何使用一个Mysql Insert语句在多个表中插入数据 [英] How To Inserting Data in Multiple Tables With One Mysql Insert statement

问题描述

是否可以仅使用1条insert语句将值插入到2个表中，从而value1，value2，value3进入表1，value 4，value5进入表2?这就是我能够想到的

is it possible to insert values in to 2 tables with just 1 insert statement, whereby value1, value2, value3 go in to table 1 and value 4, value5 go in to table 2? this is what i was able to come up with

BEGIN TRANSACTION;insert into flightinformation(origincity,destinationcity) values (''"value1"'',''value2"'');insert into ticketreservation(journeydate,customername,customeraddress) values (''"value4"'',''"value5"'',''"value6"'');COMMIT;

推荐答案

使用单个SQL语句是不可能的.但是，为什么不编写一个存储过程来做到这一点呢?然后，您可以使用一个语句来调用存储过程，这同样好.

It''s not possible with a single SQL statement. But why not just write a stored procedure to do it? Then you have the ability to just call the stored procedure with a single statement, which is just as good .

这篇关于如何使用一个Mysql Insert语句在多个表中插入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！