使用mysql/innodb在2个表中创建2条记录

如果表1中的id是自动递增的,那么可以这样做:

INSERT INTO t1 (name) VALUES ('whatever');
INSERT INTO t2 (fid) VALUES (LAST_INSERT_ID());

这个来自 MySQL Reference Manual .

然后你可以这样做:

INSERT INTO t1 (name) VALUES ('whatever');
SET @id=LAST_INSERT_ID();
INSERT INTO t2 (fid) VALUES (@id);
INSERT INTO t3 (fid) VALUES (@id);
...