MySQLCC probably uses the backtick (`) to escape stuff so it issued
UNIQUE KEY `IDX_Postcode-Location` (Postcode,Location)
and not
UNIQUE KEY IDX_Postcode-Location (Postcode,Location)
It has been mentioned on the list a few times in the last couple months that
if you escape strings containing hyph
On Wed, Jan 15, 2003 at 11:44:24AM +1100, Daniel Kasak wrote:
> Hi all,
>
> I recently had to restore from a backup and discovered that mysql didn't
> want to re-create a table which had the minus symbol (-) in it, eg
Yeah, you need to quote such names now.
Upgrade your version of mysqldump and