mysql创建表怎么解决方案_MySql创建表遇到的问题

SQL语句如下：

CREATE TABLE IF NOT EXISTS `student`{

`id` INT(4) NOT NULL COMMENT '学号',

`name` VARCHAR(30) NOT NULL DEFAULT '匿名' COMMENT '姓名',

`pwd` VARCHAR(20) NOT NULL DEFAULT '23456' COMMENT '密码',

`sex` VARCHAR(2) NOT NULL DEFAULT '男' COMMENT'性别',

PRIMARY KEY(`id`)

}ENGINE=INNODB DEFAULT CHARSET=UTF8

报错：

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

`id` INT(4) NOT NULL COMMENT '学号',

`name` VARCHAR(30) NOT NULL DE' at line 1

解决方案：

把CREATE TABLE IF NOT EXISTS `student`{

}之后的{}括号改成()