Thread: MySQL Query Field Name Issue?

I am trying to execute a MySQL query, and keep getting the "There is a problem with this SQL statememnt - Please Check it!" error. It is a query that I have used in phpMyAdmin and in several PHP scripts, so I know it works. Through a process of elimination and simplification of the query, I have determined that the error only happens when a particular field is included in the query. The name of the field is "Mode". For some reason SQL Drill does not like this field, and always gives me the error whenever it is present in the query in any fashion.

I have tried copying and pasting the query into SQL Drill and using the expression builder (not sure if that's what it's called) to no avail. Also, when I use the expression builder to add that field to the query, it puts quotes around the field name for some reason.

Is "Mode" a restricted field name that I'm not aware of? I must admit I am no MySQL expert.

Thanks for your help.

Hi

Sorry you are having this issue.

What type of SQL statement is causing a problem ? SQL Drill is only for running SELECT statements at the moment.. If the query is a SELECT then please could you post up a version of the SQL and I can try to replicate the issue.

One other thing to know would be the data type of the Mode field.

I can take a look at this later today if you can send over those details. Thanks and have a nice day