PDA

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?

raf
01-20-2005, 08:29 PM
what's "a filed"

alaios
01-20-2005, 09:15 PM
field... thx

Kiwi
01-20-2005, 10:18 PM
INSERT INTO table1(key_fields,random_column) VALUES (key_value,RAND());

or

UPDATE table1 SET random_column = RAND() WHERE <identify records>;