mysql - 这个SQL有什么错误，如何解决？

Question

我是新手，看不懂这个mysql语法的错误。谁能帮忙？

 mysql> CREATE TABLE IF NOT EXISTS 'tbl_issue'
        -> (
        -> 'id' INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
        -> 'name' varchar(256) NOT NULL,
        -> 'description' varchar(2000),
        -> 'project_id' INTEGER,
        -> 'type_id' INTEGER,
        -> 'status_id' INTEGER,
        -> 'owner_id' INTEGER,
        -> 'requester_id' INTEGER,
        -> 'create_time' DATETIME,
        -> 'create_user_id' INTEGER,
        -> 'update_time' DATETIME,
        -> 'update_user_id' INTEGER
        -> ) ENGINE = InnoDB
        -> ;

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 ''tbl_issue' ( 'id' INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, 'name' varchar(2' at line 1 mysql> CREATE TABLE 'tbl_issue' -> (

Answer 1

反引号应该用于表名和字段名，而不是单引号。