mysql - mysql 语法错误 - 插入查询

Question

所有列名称都是正确的，数据类型也应该没问题，但这会抛出:

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 'desc, owner, burl) VALUES ('1', '2', '3', '4', '5')' at line 1

mysql_query("INSERT INTO servers (ip, name, desc, owner, burl) VALUES ('1', '2', '3', '4', '5')") or die(mysql_error());

Answer 1

mysql_query("INSERT INTO servers (ip, name, `desc`, owner, burl) VALUES ('1', '2', '3', '4', '5')") or die(mysql_error());

确保对使用 DESC 等特殊单词的列名称加反引号