UPDATE mytable SET password = (SELECT SUBSTRING(CONVERT(varchar(60),NEWID()), 1, 6)) WHERE password IS NULL 转载于:https://blog.51cto.com/const/692352