The update implementation copies data from one table to another table

I want to copy the contents of a field from the article table to the B field in the article table. The SQL statement is:

The code is as follows	Copy Code
Update article set b=a;

Example

The code is as follows	Copy Code
UPDATE File_manager_folder F1 Left OUTER JOIN file_manager_folder F2 On f1.name = F2.name and F2.parentid = 54 SET F1.parentid = 54 WHERE F2.name is NULL and f1.id in (1,2,3);

The SQL syntax is written like this.

Example

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;