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>;

01-20-2005, 08:23 PM	PM User \| #1
alaios Regular Coder Join Date: Aug 2002 Posts: 421 Thanks: 0 Thanked 0 Times in 0 Posts	insert randomly data Hi i need to enter some integer numbers (randomly) into a filed... any idea?

01-20-2005, 08:29 PM	PM User \| #2
raf Master Coder Join Date: Jul 2002 Posts: 6,589 Thanks: 0 Thanked 0 Times in 0 Posts	what's "a filed" __________________ Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

01-20-2005, 09:15 PM	PM User \| #3
alaios Regular Coder Join Date: Aug 2002 Posts: 421 Thanks: 0 Thanked 0 Times in 0 Posts	i mean field field... thx

01-20-2005, 10:18 PM	PM User \| #4
Kiwi Regular Coder Join Date: Oct 2002 Posts: 379 Thanks: 0 Thanked 0 Times in 0 Posts	INSERT INTO table1(key_fields,random_column) VALUES (key_value,RAND()); or UPDATE table1 SET random_column = RAND() WHERE <identify records>; __________________ Strategy Conscious

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread: