常用sql记录
# 1. 将一个表中字段的值赋值到另一个表中字段
-- 将 表TABLE1中字段COLUMN 赋值给 表TABLE2中字段COLUMN_BAK
update (select A.COLUMN column1,B.COLUMN_BAK column1_bak from TABLE1 A,TABLE2 B where A.ID=B.ID) C set C.column1_bak=C.column1;
update
(select A.THIRDPART_EMPLOYEE_NO, B.EMPLOYEE_NO from THIRDPART_USERS_RELATION A, THIRDPART_USERS B where A.THIRDPART_LOGIN_NAME = B.LOGIN_NAME) C
set C.THIRDPART_EMPLOYEE_NO = C.EMPLOYEE_NO where C.EMPLOYEE_NO is not null ;
1
2
3
4
5
6
2
3
4
5
6
# 2. 将一个表中多个字段更新
-- 将 表TABLE1 中字段COLUMN1和COLUMN2 置为null
update TABLE1 set COLUMN1 = null, COLUMN2 = null where ID is not null;
1
2
2
# 3. 删除表中的记录[DELETE]
-- 删除 表TABLE1 中的记录
DELETE FROM TABLE1 WHERE ID = '123';
1
2
2