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