[Phpmyadmin-devel] Parser problem with PhpMyAdmin 2.3.0

[Jocelyn Fournier]

Hi,

I agree with you, but password is not part of the restricted words list.
(http://www.mysql.com/doc/en/Reserved_words.html)
e.g :

mysql> SELECT password FROM inscrit LIMIT 1;
+------------+
| password   |
+------------+
| 03895021 |
+------------+
1 row in set (0.06 sec)

As you can see, this command is perfectly legal and doesn't require
backtick.

Regards,
  Jocelyn


----- Original Message -----
From: "Marc Delisle" <Delislma at CollegeSherbrooke.qc.ca>
To: "Jocelyn Fournier" <joc at presence-pc.com>
Cc: <phpmyadmin-devel at lists.sourceforge.net>
Sent: Wednesday, August 21, 2002 3:41 PM
Subject: Re: [Phpmyadmin-devel] Parser problem with PhpMyAdmin 2.3.0


> Jocelyn,
>
>
> from the MySQL doc:
> "Note that if the identifier is a restricted word or contains special
> characters you must always quote it with a ` (backtick) when you use it".
>
> http://www.mysql.com/doc/en/Legal_names.html
>
>
> Jocelyn Fournier wrote:
>
> > Hi,
> >
> > I just want to report a small bug.
> > If I have a query with a field named "password", it is parsed as it was
the
> > MySQL keyword PASSWORD, which is not the case.
> >
> > e.g :
> >
> > INSERT INTO inscrit
> > (pseudo,email,password,icq,homepage,hobby,occupation,ville) SELECT
> >
username,user_email,user_password,user_icq,user_website,user_occ,user_intere
> > sts,user_from FROM montgallet2.users
> >
> > is displayed as :
> >
> > INSERT INTO inscrit( pseudo, email,
> > PASSWORD , icq, homepage, hobby, occupation, ville )
> > SELECT username, user_email, user_password, user_icq, user_website,
> > user_occ, user_interests, user_from
> > FROM montgallet2.users
> >
> > Regards,
> >   Jocelyn Fournier
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by: OSDN - Tired of that same old
> > cell phone?  Get a new here for FREE!
> > https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
> > _______________________________________________
> > Phpmyadmin-devel mailing list
> > Phpmyadmin-devel at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> >
> >
>
>
> --
> Marc Delisle
>
>
>
>
>