faqts : Computers : Databases : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

94 of 166 people (57%) answered Yes
Recently 3 of 10 people (30%) answered Yes

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.