mySQL如何复制多条一条或多条记录 |
您所在的位置:网站首页 › mysql复制粘贴快捷键 › mySQL如何复制多条一条或多条记录 |
复制记录到另外的表
前提是另外的表article_bak已存在 ① insert into article_bak(title,keywords,desc,contents) select title,keywords,desc,contents from article where article_id = 100; 复制记录到当前表一、复制表里面的一条记录并插入表里面 ① insert into article(title,keywords,desc,contents) select title,keywords,desc,contents from article where article_id = 100; 复制并修改字段内容 ② insert into article(title,keywords,desc,contents) select ‘test’ as title,keywords,desc,contents from article where article_id = 100; 二、复制表里的多条数据记录,并插入到表里面 ① INSERT 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); 在创建表时,就插入另一张表里面的某些数据① create table user AS select * from member where id < 10 |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |