[Phpmyadmin-devel] Parser problem with PhpMyAdmin 2.3.0

[Marc Delisle]

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