title: Generate 6 digit random number in mysql
body: <p>I want to generate random 6 digit number in mysql but sometime it generate only 5 digit. </p>
  
  <p><code>UPDATE member SET updates = FLOOR(RAND() * 999999)</code></p>