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@CollegeSherbrooke.qc.ca To: "Jocelyn Fournier" joc@presence-pc.com Cc: phpmyadmin-devel@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

-- Marc Delisle