|
1 2 |
UPDATE oldpeoplebaseinfo SET Birthday = '06-04-1900' WHERE Birthday NOT LIKE '%-%-%'; |
update column Birthday with randoms
|
1 2 3 4 5 6 7 |
UPDATE oldpeoplebaseinfo SET Birthday = CONCAT( MOD(FLOOR(RAND()*100),12), '-', MOD(FLOOR(RAND()*100),31), '-19', MOD(FLOOR(RAND()*100) + 10,99) ); |
if length of birthday string is less than 9
|
1 2 3 4 5 6 7 |
UPDATE oldpeoplebaseinfo SET Birthday = CONCAT( MOD(FLOOR(RAND()*100),12), '-', MOD(FLOOR(RAND()*100),31), '-1910') WHERE LENGTH(Birthday) < 9; |
set nationality using LOOR RAND()
|
1 2 |
UPDATE oldpeoplebaseinfo SET Nation = IF( FLOOR(RAND() * 100) > 66, '单身汉 ', IF( FLOOR(RAND() * 100) < 33, '大师 ', '博士')); |
Update Code, which is a VARCHAR(40)
|
1 2 |
UPDATE oldpeoplebaseinfo SET Code = SUBSTRING(MD5(RAND()) FROM 1 FOR 40); |
Gender
|
1 2 |
UPDATE oldpeoplebaseinfo SET Gender = IF( FLOOR(RAND() * 100) > 50, '男', '女'); |