Mysql 修改字段值提示ERROR 1064 (42000): You have an error in your SQL syntax； check the manual that corresp

Mysql修改字段值提示：

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rows'='67' at line 1

MariaDB [office_db]> update data_person_size_da set rows='67' where id=12;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rows'='67' at line 1

问题原因：

报错明显是SQL语句有错误，是由于rows为mysql中的关键词，对于含有关键词的字段值应该用反引号释义出来，正确写法为：

MariaDB [office_db]> update data_person_size_da set `rows`='67' where id=12;