MySQL query for table name??

[Armitage]

I could do "SHOW TABLES" and then work through the output to see if the table exists. But is there a more direct way to query for the existance of a single table?

 

[akubi]

SHOW TABLES FROM dbname LIKE 'tablename';

 

[Armitage]

:thumbsup:
Thanks - in fact you don't need the "FROM dbname" either if you're already using it.

 

[WildHorse]

And,
DESC <tableName>;
will display that table's structure, which can be pretty useful.

 

[Armitage]

Originally posted by: scott
And,
DESC <tableName>;
will display that table's structure, which can be pretty useful.

Yep, use that one all the time.