MySQL的SQL语句写法,除了那些基本的之外,还有一些也算比较常用的,这里记录下来,以便以后查找。 好记性不如烂笔头,这话说的太有道理了,一段时间不写它,还真容易忘记。大家不要纠结这些SQL语句包含的业务或是其它问题,本文只是一篇笔记而已。
将数据从T1表导入到T2表
INSERT INTO T2 (C1,C2) SELECT C1,C2 FROM T1 [WHERE C1 = XX AND C2 = XX ORDER BY C1]
使用T2表的NAME来更新T1表的NAME
UPDATE T1 AS A, T2 AS B SET A.NAME = B.NAME WHERE A.TID = B.ID
两表的关联更新
UPDATE T_ROLE_USER AS A, ( SELECT ID FROM T_USER WHERE DEPARTID IN ( SELECT ID FROM T_DEPART WHERE LENGTH(ORG_CODE) = 9 ) ) AS B SET A.ROLEID = '123456' WHERE A.USERID = B.ID
自己和自己关联更新
UPDATE T_DEPART AS A, ( SELECT ID, SUBSTRING(ORG_CODE, 1, 6) ORG_CODE FROM T_DEPART WHERE LENGTH(ORG_CODE) = 8 AN