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.
I thought that this could be done using a temporary table in a batch script that is unique to that session e.g. create temporary table Ttable1 (select * from masterlist where ref='ABCDE'); update Ttable1 set ref='SMI0C001'; insert into sublist select * from Ttable1; drop Ttable1; I know the above syntax doesn't work but it shows the steps I am looking to take. Hope this makes enough sense to be able to answer. Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]