Re: Reserved words in MySQL update

2001-02-15 Thread Benjamin Pflugmann
Hi. On Wed, Feb 14, 2001 at 03:28:23PM -, [EMAIL PROTECTED] wrote: > >Description: > Upgrading from 3.22 to 3.23 with a field having a reserved name > ALTER TABLE barfs and doesn't let me do > ALTER TABLE casualties CHANGE when cas_when DATE NOT NULL; ALTER TABLE casualties CHANGE `when` cas

Reserved words in MySQL update

2001-02-14 Thread david
upgrade to 3.23 >Fix: Manually edited the .frm file - didn't feel right Need something to either do it automatically on upgrade, or a standalone utility to modify the mysql files directly. >Submitter-Id: >Originator:David Croft >Organization: >MySQL support: none >S