Category Archives: MySQL

Generate random birth date in MySQL table and get Age by select

Posted on July 23, 2011 by Lukáš Gavenda

Today I was solving generating of random data for testing and manipulation with the date of the birth. Here are two simple SQL queries solving both: Query for generate random date of birth in whole table UPDATE people SET date_of_birth=CONCAT_WS(‘-’,(FLOOR( … Continue reading →

Posted in MySQL, PHP & MySQL | Leave a comment