MySQL Syntax error - table name

Question

I'm running into a strange problem with mysql does not like my table name.

mysql> DROP TABLE IF EXISTS 6e0OU1QgkU7Pj6ycQF0U_results;
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 '6e0OU1QgkU7Pj6ycQF0U_results' at line 1

mysql> DROP TABLE IF EXISTS 6epGz4xKzfKd6A9e1ASP_results;
Query OK, 0 rows affected (0.00 sec)

mysql>

Any idea why the first query has a syntax error while the second query is allowed?

Damian Yerrick · Accepted Answer · 2015-04-07 14:41:33Z

5

It's probably the 6e0, which the SQL parser thinks is a number in scientific notation: 6 * 10⁰.

answered Apr 7, 2015 at 14:41

Damian Yerrick

4,6842 gold badges28 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

CodeGodie Over a year ago

this sounds like a more probable answer

barbiepylon Over a year ago

This is probably right, but no solution is provided...I think using quotes as Abhik suggested is probably the correct solution!

Abhik Chakraborty · Accepted Answer · 2015-04-07 14:46:51Z

2

Thats because mysql does not recognize the table name since it starts with a digit MeN

Identifiers may begin with a digit but unless quoted may not consist solely of digits.

https://dev.mysql.com/doc/refman/5.0/en/identifiers.html

It is recommended that you do not use names that begin with Me or MeN, where M and N are integers. For example, avoid using 1e as an identifier, because an expression such as 1e+3 is ambiguous. Depending on context, it might be interpreted as the expression 1e + 3 or as the number 1e+3.

You can try as

DROP TABLE IF EXISTS `6e0OU1QgkU7Pj6ycQF0U_results`;

edited Apr 7, 2015 at 14:46

answered Apr 7, 2015 at 14:41

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

3 Comments

jpw Over a year ago

This answer is incorrect, which is apparent as the second example works. Also, the text you quote directly contradicts your assertion.

Abhik Chakraborty Over a year ago

The reson is you can not use the identifier begins as MeN where M and N are digit.

barbiepylon Over a year ago

I think the quotes will solve the issue but not for the reason that this answer states. This portion is irrelevant, "Identifiers may begin with a digit but unless quoted may not consist solely of digits."...

Collectives™ on Stack Overflow

MySQL Syntax error - table name

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related