MYSQL: Check if table exists does not work

Question

IF OBJECT_ID(N`db_291702_2`.`aaCoRrankingDateManage`, N'U') IS NOT NULL
BEGIN
  PRINT 'Table Exists'
END

What is wrong with this? Why do I get errors? Neither of the suggested ways in how-to-check-if-a-table-exists-in-sql-server/ works for me.

PS. "does not work" means errors like

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''db_291702_2'.'aaCoRrankingDateManage' LIMIT 0, 30' at line 1

Additional info: I am using phpMyAdmin, my two databases are called db_291702_1 and db_291702_2, the latter has two tables, one of them is called aaCoRrankingDateManage

single quotes are for encapsulation of strings, not table names — Félix Adriyel Gagnon-Grenier, Jul 23 '14 at 13:28
look at the code coloring. you have an odd number of single quotes, which will trouble the sql — Félix Adriyel Gagnon-Grenier, Jul 23 '14 at 13:32
I can't seem to find any working exemple of MySQL with `OBJECT_ID()`, neither can I find it on the official MySQL reference... maybe it's not a MySQL function? this guy has similar problem: http://board.issociate.de/thread/260989/Detect-if-table-exists-from-within-MySQL.html — Félix Adriyel Gagnon-Grenier, Jul 23 '14 at 13:38
I think the accepted answer can help you even more: http://stackoverflow.com/questions/1525784/mysql-check-if-a-table-exists-without-throwing-an-exception — Félix Adriyel Gagnon-Grenier, Jul 23 '14 at 13:54

score 0 · Answer 1 · answered Jul 23 '14 at 13:22

If you want to escape table or column names then use backticks

select `group` from table1

A static string must be included in quotes

select * from users where name = 'john'

And the syntax of every DB engine is a little bit different. The above works for MySQL, but SQL-Server has a different syntax. There you use brackets [] to escape names.

But you only need to escape names if you use reserved words. You don't have to escape everything.

phil294 · Accepted Answer · 2017-04-12T12:22:17.843

-1

The given source code is no MySQL Code.

edited Apr 12 '17 at 12:22

answered Dec 12 '14 at 00:49

phil294

10,038
8
65
98

MySQL uses SQL. Do you mean this is T-SQL? – Cobolt Apr 12 '17 at 10:21
in Mysql use this `if exists table_name1,table_name2...` – wonbin2011 Oct 22 '19 at 10:06

MYSQL: Check if table exists does not work

2 Answers2