MySQL database table field using keywords such as desc error and resolution method

<!--  desc is a key word for the MySQL database, and using it as a field name will error-

<sql id= "Base_column" >id,mol,ip,port,name,t.desc,maxac,maxi,mini,maxw,status
</sql><!--Query List-    <select id= "gettht" resultmap= "Baseresultmap" parametertype= "Thigdo" >        Select <include refid= "Base_column"/> from t_sys_thorfd t order by status Desc        <include refid= "where"/ >    </select>





A simple query statement has been an error in the location of Desc, at first thought it was

ORDER BY Status Desc error, check multiple times, suspected DESC is the name of the field to blame, after verifying that, DESC is often used as a field name to identify the meaning of the  description

The solution is to use the above curve to salvation, or replace the field name.

Another way to do this is to add an anti-quote marker where you want to use the keyword, for example

<if test= "desc! = null and desc!=" ">
' Desc ',
</if>

MySQL database table field using keywords such as desc error and resolution method