Hi;
I made a lot of research but I couldnt find what I want. Is there any function in MySQL which detects is there any table called "x" or not? I wnat to detect it and if it doesnt exist a SQL sentence will create a table. How can I do that? (I think a stored procedure can help me but how can I detect the existence of a table?)

Thanks Im tring it...

How can use it with SQL commands?
I tried something like this:
IF((select count(*)
from information_schema.tables
where table_schema = 'db_name'
and table_name = 'x')=0,CREATE TABLE....)
But it didnt work. I dont want to use a stored procedure. Is there any other way?

other ways?

1. run the query, look at the count, and if it's zero, run the CREATE

2. embed the query in a language like php which has IF statements

3. use a stored proc

Use -

Of course if you just want to find out if the table exists (i.e. not create it but produce a list of available tables?) then using the last option is not valid.

If you have MySQL 5+ use the information_schema tables. Definitely the way to go...

thanks very much...