How to create a random float value in mysql?07.12.13

to create a random float value and than round it to a 2 decimal place you can use see this example: update product set price = ROUND(RAND(2) * 100,2); 07.12.13

http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_round

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024