Amazing SQL Error 1024 when create database in Mariadb

Question

when execute create database if not exists 7e7 ;

get error:

" SQL Error [1064] [42000]: (conn:67) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '7e7' at line 1 Query is : create database if not exists 7e7 "

but execute create database if not exists 7b7 ;, its ok.

why?

docker container, mariadb:10.2

version 10.2.19-MariaDB-1:10.2.19+maria~bionic

Rick James · Accepted Answer · 2018-11-22 03:59:08Z

0

7e7 looks too much like the number 70,000,000, in scientific notation.

When in doubt, surround database, table, and column names with backtics:

`7e7`

answered Nov 22, 2018 at 3:59

Rick James

144k15 gold badges144 silver badges255 bronze badges

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

Collectives™ on Stack Overflow

Amazing SQL Error 1024 when create database in Mariadb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related