check table

[giuseppeitaliano]

How can I control if a table already exists?

 

[RaceAap]

With:

SHOW TABLE STATUS FROM db_name LIKE 'wild table name'

you can check if the table name excists and what the status is.

Take a look at:

http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html

for more details

Thanx,

Lon