We thought of upgrading MySQL to new version 5.5.16. While testing the scripts with the new version, I had found one column Maxvalue is a Keyword in latest version.
For this one, we need to change all the application where it is used. Instead is there any way to make the keyword Maxvalue interpret as a Normal column, so that we will not have to change our application.
Maxvalue is just column name, it is not the maximum value.
And I am looking for some other option apart from backticks: `Maxvalue`.