mysql 语法问题 求帮助 谢谢

Question

CREATE TABLE douyin_webcast(  id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,   room_id INT(50) NOT NULL DEFAULT 0,   user_id VARCHAR(100) NOT NULL DEFAULT '',   timetamp BIGINT(20) NOT NULL DEFAULT 0,   action CHAR(20) NOT NULL DEFAULT '',   extension VARCHAR(600) NOT NULL DEFAULT 0,   PRIMARY KEY (`Id`), )DEFAULT CHARSET=UTF8 TYPE=INNODB;

报错如下

CREATE TABLE douyin_webcast(  id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,   room_id INT(50) NOT NULL DEFAULT 0,   user_id VARCHAR(100) NOT NULL DEFAULT '',   timetamp BIGINT(20) NOT NULL DEFAULT 0,   action CHAR(20) NOT NULL DEFAULT '',   extension VARCHAR(600) NOT NULL DEFAULT 0,   PRIMARY KEY (`Id`), )DEFAULT CHARSET=UTF8 TYPE=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 ')DEFAULT CHARSET=UTF8 TYPE=INNODB' at line 1

这个 括号后面的 DEFAULT 如何写的？
有人知道吗？

Answer 1

试下这样?

CREATE TABLE douyin_webcast (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    room_id INT(50) NOT NULL DEFAULT 0,
    user_id VARCHAR(100) NOT NULL DEFAULT '',
    timetamp BIGINT(20) NOT NULL DEFAULT 0,
    action CHAR(20) NOT NULL DEFAULT '',
    extension VARCHAR(600) NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`)
)  DEFAULT CHARSET=UTF8 ENGINE=INNODB;

type=InnoDB在5.0以前使用，5.0后使用ENGINE=INNODB