MySQl sql语法,实现查询结果插入另外一张表。
insert into sys_user_post(user_id, post_id) select id,post_id from sys_user where del_flag = '0' and post_id is not null;
MySQl sql语法,实现查询结果插入另外一张表。
insert into sys_user_post(user_id, post_id) select id,post_id from sys_user where del_flag = '0' and post_id is not null;