FYI, the atomicity of rename and using it to swap tables is discussed in the manual here:
http://dev.mysql.com/doc/mysql/en/RENAME_TABLE.html Justin On Tue, 10 Aug 2004 13:50:34 -0700, Haitao Jiang <[EMAIL PROTECTED]> wrote: > It would be great if there is a swap table command that is atomic. > > Thanks a lot > > Haitao > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]