mysql用变量存储插入的id

最新推荐文章于 2022-05-27 10:52:13 发布

weixin_34061555

最新推荐文章于 2022-05-27 10:52:13 发布

阅读量157

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/xingmeng/p/3482098.html

版权

INSERT into a(value) values ('test');
#set @last_id = LAST_INSERT_ID();
set @last_id = (select max(id) from a);
INSERT INTO b (a_id, `value`) values (@last_id, 'aaaa');
INSERT INTO b (a_id, `value`) values (@last_id, 'tetete');

INSERT into a(value) values ('bbbtest');
set @last_id = (select max(id) from a);
INSERT INTO b (a_id, `value`) values (@last_id, 'aaaa');
INSERT INTO b (a_id, `value`) values (@last_id, 'tetete');

转载于:https://www.cnblogs.com/xingmeng/p/3482098.html