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?)
How can use it with SQL commands?
I tried something like this:
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?