On Jan 17, 2008 2:22 PM, Kerry Frater wrote: > Can someone please advise. I am looking to create a "multiuser" friendly way > of getting a subset number of rows from a table into another whilst making a > modification.
> create temporary table Ttable1 (select * from masterlist where ref='ABCDE'); > update Ttable1 set ref='SMI0C001'; > insert into sublist select * from Ttable1; > drop Ttable1; How about: INSERT INTO sublist (ref, field1, field2, field3) SELECT 'SMI0C001' , field1 , field2 , field3 FROM masterlist WHERE ref='ABCDE' ; Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]