====== MySQL - Debugging messages ======

<code mysql>
select concat ("Updated ", row_count(), " rows") as '';
#DATE(DATE_SUB(NOW(), INTERVAL ROUND(RAND(1)*10) DAY));
select concat ("Random date: ", DATE(DATE_SUB(NOW(), INTERVAL ROUND(RAND(1)*100) DAY))) as '';
</code>

===== Examples =====

Output a random date:

<code mysql>
select addtime(concat_ws(' ','1964-12-25' + interval rand()*20000 day ,'00:00:00'),sec_to_time(floor(0 + (rand() * 86401)))) as '';
</code>