UPDATE 表 SET 字段1=xx1,字段2=xx2 WHERE (字段3=xx3 OR 字段3=xx4)
//注:括号内可用循环
删除全表所有数据
truncate table 表名;
去重查询
select distinct 列1,列2
from
(
select语句1
)
例子:SELECT DISTINCT KSRW_ID FROM (SELECT KSRW_ID FROM T_KWGL_JKJS) AS TOTAL,尤其需要注意的要取别名,也就是AS TOTAL
//注:括号内可用循环
删除全表所有数据
truncate table 表名;
去重查询
select distinct 列1,列2
from
(
select语句1
)
例子:SELECT DISTINCT KSRW_ID FROM (SELECT KSRW_ID FROM T_KWGL_JKJS) AS TOTAL,尤其需要注意的要取别名,也就是AS TOTAL