SELECT DATA INTO @DATA FROM TABLE1 WHERE ID = 1
UPDATE TABLE1 SET DATA = @DATA
WHERE ID = 2
如果想一条语句搞掂,那么这样写
UPDATE TABLE1 A, TABLE1 B SET A.DATA = B.DATA
WHERE B.ID = 1
AND A.ID = 2
mysql里如何最快速度从一张表里取3列的值复制到另一张表里,有1亿条数据一、复制表里面的一条记录并插入表里面
① insert into article(title,keywords,desc,contents) select 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
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)