• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

zitter on 10/13/11

Tagged

Versions (?)

10/13/11 07:02pm

 / Published in: MySQL

 

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   Tweet

Comments

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