php - 创建表 : Syntax error

Question

CREATE TABLE IF NOT EXISTS 'wp_gom_my_project' (
'my_project_id' int NOT NULL auto_increment,
'my_project_name' text NOT NULL ,
'user_id' int NOT NULL ,
'my_project_description' text NOT NULL ,
'my_project_deadline' datetime NOT NULL ,
PRIMARY KEY  (`my_project_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8

我只是找不到错误。

这是错误信息:

#1064 - 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 ''wp_gom_my_project' ( 'my_project_id' int NOT NULL auto_increment, 'my_project' at line 1

Answer 1

你的引号有误:

• ' 用于引用字符串
• ` 用于引用标识符(表名、列名等)

因为无论如何您的表名或列名都不是关键字，所以根本不加任何引号，这样看起来会好得多。 :)