-- 定义变量num并初始化为0
SET @num = 0;
-- 执行INSERT INTO SELECT语句,将变量num作为主键id插入表中
INSERT INTO table_a (id, column1, column2, ...)
SELECT @num := @num + 1, column1, column2, ...
FROM table_b;
取当前表中的最大id值作为num的初始值
-- 定义变量num并初始化为table_a 主键最大值
SET @num := (select max(id) from table_a);
-- 执行INSERT INTO SELECT语句,将变量num作为主键id插入表中
INSERT INTO table_a (id, column1, column2, ...)
SELECT @num := @num + 1, column1, column2, ...
FROM table_b;