Hi.
On Wed, Feb 14, 2001 at 03:28:23PM -0000, [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_when DATE NOT NULL;
should work. Note, that backticks will allow to use reserved words or
special characters in table, field and other names/labels.
Bye,
Benjamin.
> cos of the reserved word "when".
> >How-To-Repeat:
> Have a field called "when" in 3.22, 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.
[...]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
