[Phpmyadmin-devel] MySQL reserved words

Robin H. Johnson robbat2 at orbis-terrarum.net
Tue Apr 15 03:26:04 CEST 2003

On Tue, Apr 15, 2003 at 12:15:48PM +0200, Michal ?iha? wrote:
> On 15.04.2003 12:11, Beck, Mike wrote:
> > i agree to adding any reserved words that are on the mysql-website but not
> > in the list, but i wouldn't delete those that are in the list and not on the
> > web - that would mean that you can have a table named 'autocommit'?? even if
> > mysql does allow it, this can only mean trouble. Robin would your parser
> > mind that?
> I don't see why we should have something different than MySQL does. With
> current version it has some bad side effects:
> On MySQL commandline: "create table autocommit (i int);" goes okay, in
> phpMyAdmin it is converted to "CREATE TABLE AUTOCOMMIT (i int)" so it
> creates uppercased table. This is IMHO something we don't want...
> If we wouldn't change case of reserved words, it would be okay, but we
> do change this so we should have same reserved words as MySQL does.

Previously I have  found that the website list is NOT up to date.
Instead I have based the list on the actual parser inside the MySQL
server (look in the yacc and flex files).

Robin Hugh Johnson
E-Mail     : robbat2 at orbis-terrarum.net
Home Page  : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ#       : 30269588 or 41961639
GnuPG FP   : 11AC BA4F 4778 E3F6 E4ED  F38E B27B 944E 3488 4E85
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 232 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20030415/4e41007e/attachment.sig>

More information about the Developers mailing list