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 ·
780 阅读 ·
0 评论