|
UPDATE |
|
语法格式 |
|
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; |
|
S1.常用更新数据用法 |
|
UPDATE test_master SET pwd = ‘admin‘ WHERE id = 1000 |
|
S2.依赖上一次的值 |
|
UPDATE test_master m SET m.id = m.id + 100 WHERE m.bindNo = ‘bn001‘ |
|
|
|
|
|
ref |
原文：https://www.cnblogs.com/zhen-android/p/10347347.html