php - 名为change的列出现奇怪的MySQL行为

Question

我试图创建一个列名为“Change”的表。这是我使用的代码

$create=mysql_query("CREATE TABLE table_name (ID int NOT NULL AUTO_INCREMENT KEY,
Name TEXT ,Property TEXT ,Change TEXT ,Change_Percent TEXT ,Low_Look TEXT ,
High_Look TEXT ,Low_Proximity TEXT ,Time_Index TEXT ,carom TEXT ,qualification 
TEXT)");

// Execute query
if (mysql_query($con,$create))
  {
  echo "Table created successfully";
  }
else
  {
  echo "Error creating table: " . mysql_error($conn);
  }

这会给我以下错误

Warning: mysql_query() expects parameter 2 to be resource, boolean given in
C:\xampp\htdocs\stock\test.php on line 20
Error creating table: 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
'Change TEXT ,Change_Percent TEXT ,Low_Look TEXT ,High_Look TEXT ,Low_Proximity TEXT '
at line 1

尝试了一些事情后，我注意到从 Change 中取出“e”解决了问题。现在可能是什么原因导致的，有没有办法将列命名为“Change”？如果绝对有必要的话。

Answer 1

Change 是保留字。您可以尝试更改为其他名称或至少用反引号括起来。