SQL UPDATE 大量更新

SQL UPDATE 大量更新


MySql, MariaDB

UPDATE A,B SET A.C2=B.C3 WHERE A.C1=B.C1;

MSSQL

UPDATE A SET A.C2=B.C3 FROM A,B WHERE A.C1=B.C1;

参照:http://cuixiaodong214.blog.163.com/blog/static/951639820104100443302/

UPDATE A SET A.C2=B.C3 FROM A JOIN B ON A.C1=B.C1;

SQL UPDATE 大量更新

原文:大专栏  SQL UPDATE 大量更新


上一篇:react图工具集成


下一篇:Team Tic Tac Toe 题解