Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Kerry Frater (kerrymyforefathers.co.uk)
Date: Thu Jan 17 2008 - 07:22:04 CST
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
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;
I know the above syntax doesn't work but it shows the steps I am looking to
Hope this makes enough sense to be able to answer.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql