MySQL 3.23.41 on Solaris
Alright, I have a system where data comes in once... or maybe a few times a day. I use this data to recreate a table, and then I need to safely and quickly replace the old table. I was thinking lock original table, drop it, and then rename the new table, but I wasn't sure the lock would stay once the table was dropped. Is this the right way to go about it? -- ___ __ __ __ _ _ ____ _ _ ____ ____ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__) ) ( )__) )( (___/(______)(__)(__)\/ (____)()(_)\_)(____) (__) Do not follow in the footsteps of men of old; seek what they sought. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
