Posted 12 April 2006 - 09:30 AM
INSERT INTO table2 (letter) SELECT letter FROM table1 ORDER BY RAND()
which takes 26 records from table1 and inserts them into the letter field of table 2
but how can i
update exsisting records in table2 and not insert?
Posted 12 April 2006 - 10:02 AM
UPDATE table2 SET `fieldname` = (SELECT letter FROM table1 ORDER BY RAND())
but i'm not 100 % on it
Posted 12 April 2006 - 10:13 AM
Posted 12 April 2006 - 10:44 AM
the () in the query hasnt worked..
any other ideas please?
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users