Menu

#5 use of reserved word in table action_defs

open
nobody
None
5
2000-12-15
2000-12-15
Anonymous
No

The newer versions of MySQL (my version is 3.23.27) will not accept
the name 'when' in table action_defs (when enum('before','after') NOT NULL,).

I changed it to e_when and the creation went ok!

Then I had to replace some php3 files calling 'when' to 'e_when'

Maybe the other enum in that table, 'trigger' will stop working in a later version
og MySQL ?

It is not a good practice to use potentially reserved words in tables ;-)

O.J.
Ole.J.Utnes@hive.no

(- sorry I did not log inn before submitting this)

Discussion


Log in to post a comment.