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]
If you're using PHP, there should be a function for it.
You can also use IF NOT EXISTS in your table commands like:
CREATE TABLE IF NOT EXISTS, so that you don't overwrite anything.
What also might come in handy here is either SHOW TABLES (provided you're in
the right database), or DESCRIBE tabl
Mysql>show tables;
Would be the easy way
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 14, 2001 10:34 AM
To: [EMAIL PROTECTED]
Subject: Table Exists
What is the e
