[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)...

Expand|Select|Wrap|Line Numbers

1. if(!(mysql_query("select * from table")))
2. {
3. echo "table not found";
4. }
5. else
6. {
7. echo "table found";
8. }
9.  

[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:

Expand|Select|Wrap|Line Numbers

1. SHOW TABLES LIKE 'myTableName';
2.  

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