开发者

What is the error in this SQL, how to fix it?

I'm a newbie who can't understand the error in this mysql syntax. Can anyone help?

 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' -> (


Backticks should be used for table and field names rather than single quotes.


Simply remove the quotes from all identifiers.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜