SQL error when viewing table data

2011-01-05
2012-12-13
  • For MySQL table data cannot be viewed when the database or table name includes a special character like '-'. The automatically generated SQL statement does not quote the database or table name. How to solve/work around this?

    My database has a name like dbu11-test and when trying to view the data of a table the generated SQL looks like this:
      select * from dbu11-test.tableName

    But this is invalid SQL-Syntax:
    "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 '-test.tableName' at line 1"

    TOra version 2.1.3

    thank you,
    Wolfgang