mysql 如何查询 a 表中所有的 id 并写入 b 表数据

This topic created in 1966 days ago, the information mentioned may be changed or developed.

就写入 id 就行，之后弄个触发器让它新增自动写入好了。
可以的话跳过已存在的 id 数据

2 replies

kaiki

Dec 22, 2020

算了，想起来了
insert into b(m_id) select id from a where id not in(select id from b);

kaiki

Dec 22, 2020

@kaiki 打错了
insert into b(id) select id from a where id not in(select id from b);