Creating MySQL database containing only numbers

ShardHostSarah

Looking to create a MySQL database from the command line using numbers.

mysql -h ip.addr.es -u root -papassword -e "CREATE DATABASE IF NOT EXISTS 234";

Fails

Yet

mysql -h ip.addr.es -u root -papassword -e "CREATE DATABASE IF NOT EXISTS test";

works.

udk

try:
mysql -h ip.addr.es -u root -papassword -e "CREATE DATABASE IF NOT EXISTS 234"

udk

...that's meant to be the database name surrounded by backticks

ska

You should always escape variables in SQL-statements.

ShardHostSarah

@udk said:
...that's meant to be the database name surrounded by backticks

That works fine thanks, just need to escape the back ticks in the line also. This can be closed.