Posted By

zitter on 10/13/11


Tagged


Versions (?)

Targa


 / Published in: MySQL
 

  1. SELECT CONCAT(CHAR(CEILING(RAND() * (69 - 65 + 1)) + 65 - 1), CHAR(CEILING(RAND() * (69 - 65 + 1)) +65 -1),CEILING(RAND()*(9-0+1)+0-1),CEILING(RAND()*(9-0+1)+0-1),CEILING(RAND()*(9-0+1)+0-1),CHAR(CEILING(RAND()* (90 - 65 + 1)) + 65 -1),CHAR(CEILING(RAND()*(90-65+1))+65-1)) AS Targa;

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: zitter on October 13, 2011

based on this snippet: SELECT CEILING(RAND() * (max - min + 1)) + min - 1?

Posted By: zitter on October 18, 2011

generate random date UPDATE tablename SET datefield= ’2005-01-01′ + interval rand()*883 day

You need to login to post a comment.