|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Update query to set random data
From: zzapper (david
tvis.co.uk)
Date: Fri Jul 01 2005 - 02:06:03 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi,
In order to generate some useful test data
eg randomnly setting the flag select_normal to 0 or 1 use the following
update tbl_products set select_normal=round(rand());
I've actually answered my own question (as usual in formulating the question you often can workout
the answer)
But anyone got any other useful queries in this line?
--
zzapper
vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?"
http://www.rayninfo.co.uk/tips/ vim, zsh & success tips
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]