Go4Expert - View Single Post - IS there any MySQL Default tables like DUAL in ORACLE.

amit_27

what is the default escape character in MySQL?

We have in ORACLE like ' " ', in MSSQL like ' [] ' which is used while creating table.

MSSQL
create table [aa/njh] (col1 INT);

ORACLE
create table "aa/njh" (col1 INT);

If I use both( ", []) in MYSQL while create table it is nor working fine.
My aim is to mhave table name with special character on numeric.

amit_27 Go4Expert Member
27May2009,15:23
	what is the default escape character in MySQL? We have in ORACLE like ' " ', in MSSQL like ' [] ' which is used while creating table. MSSQL create table [aa/njh] (col1 INT); ORACLE create table "aa/njh" (col1 INT); If I use both( ", []) in MYSQL while create table it is nor working fine. My aim is to mhave table name with special character on numeric.