mysql语句解析出错_求分析这mysql语句错误在哪里

CREATEDATABASEIFNOTEXISTS`shopImooc1`;USE`shopImooc1`;DROPTABLEIFEXISTS`imooc_admin`;CREATETABLE`imooc_admin`(`id`int(10)auto_incrementkey,`username`varchar(20)notnulluni...

CREATE DATABASE IF NOT EXISTS `shopImooc1`;

USE `shopImooc1`;

DROP TABLE IF EXISTS `imooc_admin`;

CREATE TABLE `imooc_admin` (

`id` int(10) auto_increment key,

`username` varchar(20) not null unique,

`password` char(32) not null,

`email` varchar(50)

);

DROP TABLE IF EXISTS `imooc_cate`;

CREATE TABLE `imooc_cate` (

`id` smallint(10) auto_increment key,

`cName` varchar(20) unique

);

DROP TABLE IF EXISTS `imooc_pro`;

CREATE TABLE `imooc_pro` (

`id` int(10) unique auto_increment key,

`pNmae` varchar(50) not null unique,

`pSn` varchar(50) not null,

`cPrice` decimal(10,2) not null,

`iPrice` decimal(10,2) not null,

`pDesc` text,

`pImg` varchar(50) not null,

`pubImg` int not null,

`isShows` tinyint(1) default 1,

`isHot` tinyint(1) default 0,

`cId` smallint not null

);

DROP TABLE IF EXISTS `imooc_user`;

CREATE TABLE `imooc_user` (

`id` int(10) auto_increment key,

`username` varchar(20) not null unique,

`password` varchar(32) not null,

`face` varchar(50) not null,

`regTime` int not null

);

DROP TABLE IF EXISTS `imooc_album`;

CREATE TABLE `imooc_album` (

`id` int(10) auto_increment key,

`pId` not null,

);

执行上面的语句。为什么会出错呢？？？？

[Err] 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 'not null,

)' at line 3

展开