mySQL Uppercase Table Name

Question

I have a database with tables already in the database. There is a table called Character that I am trying to access to add an additional column. However any command that I use with the table Character gives me the following error:

    mysql> SHOW FIELDS FROM Character;
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 'Character' at line 1

I've tried the following commands:

mysql> SHOW FIELDS FROM "Character";
mysql> SHOW FIELDS FROM 'Character';
mysql> SHOW FIELDS FROM Character;

All three give me the same error. I have already selected the appropriate database that contains the Character table using the command "USE dbname;"

did yo try `SHOW TABLES` ? Or maybe you need `SHOW COLUMNS FROM mydb.\`Character\`;` OR `SHOW COLUMNS FROM \`Character\`;` — Juan Carlos Oropeza, Mar 21 '17 at 01:57
Ah. I was typing 'Character' instead of the one with ` `. Thanks! — FShiwani, Mar 21 '17 at 02:04

score 4 · Accepted Answer · edited May 23 '17 at 11:46

4

Character is a reserved word therefore you should use backticks:

SHOW FIELDS FROM `Character`;

See it here 9.3 Keywords and Reserved Words

Also, about the "Uppercase" (or not), read this answer Are table names in MySQL case sensitive?

On this image I'm using MySql Workbench

edited May 23 '17 at 11:46

Community

1
1

answered Mar 21 '17 at 02:01

Jorge Campos

22,647
7
56
87

mySQL Uppercase Table Name

1 Answers1