Dan Nelson wrote: > To be completely safe, you would want to use innodb tables, then select > only the primary key of the 50,000 records you're interested in, using > the "FOR UPDATE" keyword (to keep others from modifying those records > while you're doing the move). Then "INSERT INTO newtable SELECT * FROM > oldtable WHERE primarykey in ( your 50,000 keys )", then "DELETE FROM > oldtable WHERE primarykey in ( your 50,000 keys )", then COMMIT, which > will cause your insertions and deletions to be truly atomic.
Ah of course - a far better idea. Thanks :) -- Ian P. Christian ~ http://pookey.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
