How to use the SQL command to write the student code of date of birth

CodePudding user response:

Is randomly generated date
Select CONCAT (FLOOR (1990 + (RAND () * 25)), '-' LPAD (FLOOR (1 + (RAND () * 12)), 2, 0), '-' LPAD (FLOOR (3 +) (RAND () * 8), 2, 0))
-- -- -- -- -- -- -- -- -- -- -- --
The 2012-11-09
Analysis of a deep understanding of MySQL resources