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