Mysql不同表复制记录
Mysql复制一条或多条记录并插入表|mysql从某表复制一条记录到另一张表
一、复制表里面的一条记录并插入表里面
1
insert into article(title,keywords,desc,contents) select title,keywords,desc,contents from article where article_id = 100;
二、复制表里的多条数据/记录,并插入到表里面
1
2INSERT INTO `power_node`(title,type,status) SELECT title,type,status FROM power_node WHERE id < 5;
INSERT into jiaban (num,overtime) SELECT num,overtime from jiaban where id IN(1,3,5,6,7,9);
三、在创建表时,就插入另一张表里面的某些数据
1
create table user AS select * from member where id < 10
本博客所有文章除特别声明外,均采用 CC BY-NC-SA 4.0 许可协议。转载请注明来自 螃蟹壳!