If you want to check before creating a table:
CREATE TABLE IF NOT EXISTS table_name;
If you want to do it before deleting:
DELETE TABLE IF EXISTS table_name;
[EMAIL PROTECTED] wrote:
: Date: Fri, 14 Dec 2001 11:34:26 -0500
: From: [EMAIL PROTECTED]
: To: [EMAIL PROTECTED]
: Subject: Table Exists
:
: What is the easiest way to check if a table exists in the current
: database? I checked the documentation, and couldn't find anything (but
: maybe I missed it).
:
: Glen
:
: ---------------------------------------------------------------------
: 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
:
--
Sherzod Ruzmetov <[EMAIL PROTECTED]>
http://www.UltraCgis.com, Consultant
989.774.6265
+----------------------------------------+
| There is nothing wrong with your tools.|
| But we can make a better one. |
+----------------------------------------+
---------------------------------------------------------------------
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