How can create a table having the name like a^b along with same column name? name?

For creating a table with such kinds of names we must have to use quote character. The quotes can be single or double depends upon ANSI_QUOTES SQL mode. 

If this mode is disabled then the identifier quote character is the backtick (“`”). Consider the following example in which we created a table named ‘select’ −

mysql> Create table `a^b`(`a^b` int);
Query OK, 0 rows affected (0.19 sec)

mysql> Create table "a^g"("a^g" int);
ERROR 1064 (42000): 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 '"a^g" ("a^g" int)' at line 1

If this mode is enabled then we can use backtick (“`”) and double quotes (“”) both as a quote character. Consider the following example in which we created the table like the above name with the help of both quote characters after enabling this mode −

mysql> Set sql_mode = 'ANSI_Quotes';
Query OK, 0 rows affected (0.03 sec)

mysql> Create table "a^d"("a^d" int);
Query OK, 0 rows affected (0.21 sec)

mysql> Create table `a^e`(`a^e` int);
Query OK, 0 rows affected (0.14 sec)

Priya Pallavi

Published on 21-Feb-2018 13:25:22

• Related Questions & Answers
• How to name a data frame column with a vector value that has the same name in R?
• How can I query for all the tables having a particular column name?
• Can we define a method name same as class name in Java?
• Can we create a table with a space in name in MySQL?
• Can a number be used to name a MySQL table column?
• Create a dynamic table name from current year in MySQL like 2019
• Change the column name from a MySQL table with Student record?
• Can a method have the same name as the class?
• MySQL query to display columns name first name, last name as full name in a single column?
• How can we change the name of a MySQL table?
• Can we create a database with a numeric name with MySQL?
• How can I change the name of an existing column from a MySQL table?
• Can JavaScript parent and child classes have a method with the same name?
• Why the java file name should be always the same as a public class name?
• Select the table name as a column in a UNION select query with MySQL?