Re: MySql Column Name Limitation

[douglas wilson]

We can create queries with or without the backtick (`) symbol in MYSQL.

Eg: SELECT * FROM TEST;

SELECT * FROM `TEST`;

backtick (`) called quoted identifiers and they tell the parser to handle the text between them as a literal string. They are useful for when you have a column or table that contains a keyword or space.

Eg: this is not work

create table my table (id int);

But the following would:

create table `my table` (id int);

the following would get an error if status was a keyword:

select status from some_table

But this one will be parsed correctly:

select `status` from some_table