Hello,

I’m facing a problem when I try to drop a table called ‘15-test003’. The query generated by
$this->dbforge->drop_table() function is this:

DROP TABLE IF EXISTS 15-test003

...which returns an error also using phpMyAdmin. The following queries produce errors too:

DROP TABLE IF EXISTS ‘15-test003’
DROP TABLE IF EXISTS “15-test003”

The following query successfully drops the table:

DROP TABLE IF EXISTS `15-test003`

Have anyone faced similar problems while work with unusual names for tables?
Is this a bug? .. or (as I suspect) I should not use names like that for Tables?

Thanks,

—
Jose P. Espinal

I’m pretty sure it’s hyphen in your table name.  Try prefixing it with the database name, as the usual rule is that if there is a period, the following word is an identifier and needs not be quoted.

Another solution that might work:

Thanks for the quick reply!

I will use one of the possible solutions or try to use ‘_’ instead of ’-’,

This is not a ‘bug’, right?. Its just a bad name from my part xD