Mysql – How to drop column named `

MySQLmysql-5.6

I managed to create a column in my MySQL database named ` (the backtick character). How can I delete it? Is there a way to escape the backtick character in a query?

Best Answer

You could try setting the sql_mode to use ANSI_QUOTES and then dropping the column that way:

SET sql_mode = 'ANSI_QUOTES';

ALTER TABLE "schema"."table" DROP COLUMN "`";

Related Solutions

MySQL – Benefits of Using Backticks in Queries

They are 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. For instance the following would not work:

CREATE TABLE my table (id INT);

But the following would:

CREATE TABLE `my table` (id INT);

Also, the following would get an error, because COUNT is a reserved keyword:

SELECT count FROM some_table

But the following would be parsed correctly:

SELECT `count` FROM some_table

I hope this helps you.

MySQL – How to Create an Access Query to Find # Symbol in a Field

For Access you can use:

WHERE obs LIKE '*[#]*'

There are three wildcard characters in Access that can be used with LIKE operator:

`*` for a string of arbitrary length (equivalent ANSI: `%`)
`?` for a single character (equivalent ANSI: `_`)
`#` for a single numeric digit 
`[` for escaping

If you want to search for one of those wildcards, you have to enclose them in brackets: [ ]

You can find more info in the msdn article: Separate But Equal Wildcard Characters in SQL Server and Access

Best Answer

Related Solutions

MySQL – Benefits of Using Backticks in Queries

MySQL – How to Create an Access Query to Find # Symbol in a Field

Related Question