Check if table is exist or not

[maheswaran]

May this question exist....But i confused...I want to check whether the table is exist or not ....


Like i run a project , on that project i create a temp tables while run time.... on that i want to chech a table is exist or not...

if employee table is exist

exit;
else
create table employee

[r035198x]

Check the refmanual for the create table syntax and read about the IF NOT EXISTS clause.

[maheswaran]

tnx,

but this one will gove more easiest way (i hope)...

if(!(mysql_query("select * from table")))
{
echo "table not found";
}
else
{
echo "table found";
}
 

[Atli]

That is an extremely wasteful method. You would in fact be fetching ALL the data from that table, just to see if it exists.

A far better way would be to use the SHOW TABLES command, like:

SHOW TABLES LIKE 'myTableName';
 

Which would return an empty set if the table doesn't exists, or a single row if it does.

P.S.
Use [code] tags when posting code examples.
Please read the Posting Guidelines before posting.

Thank you.
MODERATOR