update实现从一张表复制数据到另一张表中
我想把article表中A字段的内容复制到article表中B字段里面sql语句为:
代码如下 | |
update article set B=A; |
例子
代码如下 | |
UPDATE file_manager_folder f1 |
sql语法这样写。
例子
mysql> UPDATE v95_soft a
RIGHT JOIN dp_softlist b ON a.id = b.softid
SET a.catid = b.softclassid;
mysql> UPDATE v95_soft set url = CONCAT(url,id);
mysql> UPDATE v95_soft set url = CONCAT(url,catid);
mysql> UPDATE v95_soft a
RIGHT JOIN dp_softlist b ON a.id = b.softid
SET a.start = b.softscore;
mysql> UPDATE v95_soft a
RIGHT JOIN dp_softlist b ON a.id = b.softid
SET a.updatetime = UNIX_TIMESTAMP(b.softcreatedate);
mysql> update v95_soft set sysadd=1;