I use the following for creating a temporary table: CREATE TEMPORARY TABLE IF NOT EXISTS tbl SELECT ...
This query may be run multiple times by the same client connection since it's part of a Web application. The problem is that if 'tbl' *does* exist, the select command is executed again and the information is duplicated in the temporary table. Is there a way to leave 'tbl' and its data alone if it exists? _______________________ Ron Bickers Logic Etc, Inc. --------------------------------------------------------------------- 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