Entry

How can I check if a table in MySQL database already exists?

Feb 16th, 2008 02:49
dman, Narendra Jain, Vladimir Ageenko, Sue Crocker, http://sturly.com

You have to use the query as:
use MySQL;
show tables like "mytab%";
This will see if tables starting with 'mytab' exist in your 'MySQL'
database or not.