小泉哥

摘要： --将更新条件保存到临时表里 CREATE TABLE tmp3 AS (SELECT username FROM oa_user WHERE username NOT IN (SELECT username FROM nst_t_account)); --更新表数据，条件从临时表里取 UPDATE oa_user SET usr_update=NOW() WHERE username I... 阅读全文

摘要： SELECT * FROM oa_user WHERE UserName IN (SELECT UserName FROM oa_user GROUP BY UserName HAVING COUNT(UserName) >1) ORDER BY UserName oa_user表名，UserName需要查重复的字段名 阅读全文