RE: Bug Report: Restrictions on index naming

2003-01-14 Thread Jennifer Goodie
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

Re: Bug Report: Restrictions on index naming

2003-01-14 Thread Jeremy Zawodny
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