Dashes in mysql database name cause failure on post

[mooreds]

Using a mysql database with a dash in the name (foo-bar) works with GETs but not with POSTs. I tried putting backticks around the database name in the sql resource file (foo-bar) but that gave this error:

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 'valuation-test``' at line 1

The error when I didn't have backticks indicated that the code was trying to connect to "-bar" (sorry, I don't have the error hanging around.

Workaround: use no dashes in your database name.

[restsql]

Neither MySQL 5.5 nor PostgreSQL 9.2 on Windows doesn't allow hyphens in database names. How were you able to create a hyphenated database?

I don't see any code in restSQL that is parsing for hyphens in fully qualified table or column names.

[mooreds]

mysqladmin -u user -ppass create test-database

works fine with mysql 5.1.54 on linux and windows.

I don't have (easy) access to mysql 5.5.

Here's a blog post on creating databases with non alphanumeric characters: http://www.chrisnewland.com/mysql-create-database-with-underscore-or-dash-in-the-database-name-193