insert into(name,name2,name)批量插入另外两个表查询的数据
INSERT INTO user_to_business_info (user_id,initial) SELECT * FROM( (SELECT id FROM `user` WHERE id>10685 AND id < 10693) AS user_id, (SELECT id FROM `goods` WHERE id>2 AND id < 10) AS initial );
原创
2021-10-26 17:55:49 ·
781 阅读 ·
0 评论