这项工作形成我,生成6位数字,并在MySQL中更新:
生成:
SELECT SUBSTRING(MD5(RAND()) FROM 1 FOR 6)
更新:
UPDATE table_name SET column_name = SUBSTRING(MD5(RAND()) FROM 1 FOR 6) WHERE id = x12