View Full Version : insert randomly data
alaios
01-20-2005, 08:23 PM
Hi i need to enter some integer numbers (randomly) into a filed... any idea?
alaios
01-20-2005, 09:15 PM
field... thx
INSERT INTO table1(key_fields,random_column) VALUES (key_value,RAND());
or
UPDATE table1 SET random_column = RAND() WHERE <identify records>;
vBulletin® v3.8.2, Copyright ©2000-2009, Jelsoft Enterprises Ltd.