?CREATE DATABASE IF NOT EXISIS 'shopImooc';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 'EXISIS 'shopImooc'' at line 1mysql> USE 'shopImooc';ERROR 1049 (42000): Unknown database 'shopimooc'mysql> --管理員表? ? -> DROP TABLE IF EXISTS 'imooc_admin';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 '--管 理員表DROP TABLE IF EXISTS 'imooc_admin'' at line 1mysql> CREATE TABLE 'imooc_admin'(? ? -> 'id' tinyint unsigned auto_increment key,? ? -> 'username' varchar(20) not null unique,? ? -> 'password' char(32) not null,? ? -> 'email' varchar(50) not null? ? -> )charset=utf8;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 ''imooc_admin'('id' tinyint unsigned auto_increment key,'username' varchar(20) ' at line 1mysql>mysql> --分類(lèi)表? ? -> DROP TABLE IF EXISTS 'imooc_cate';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 '--分 類(lèi)表DROP TABLE IF EXISTS 'imooc_cate'' at line 1mysql> CREATE TABLE 'imooc_cate'(? ? -> 'id' smallint unsigned auto_increment key,? ? -> 'cName' varchar(50) unique? ? -> )charset=utf8;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 ''imooc_cate'('id' smallint unsigned auto_increment key,'cName' varchar(50) uni' at line 1mysql>mysql> --產(chǎn)品表? ? -> DROP TABLE IF EXISTS 'imooc_pro';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 '--產(chǎn) 品表DROP TABLE IF EXISTS 'imooc_pro'' at line 1mysql> CREATE TABLE 'imooc_pro'(? ? -> 'id' int unsigned auto_increment key,? ? -> 'pName' varchar(50) not null unique,? ? -> 'pSn' varchar(50) not null,? ? -> 'pNum' int unsigned default 1,? ? -> 'mPrice' decimal(10,2) not null,? ? -> 'iPrice' decimal(10,2) not null,? ? -> 'pDesc' text,? ? -> 'pImg' varchar(50) not null,? ? -> 'pubTime' int unsigned not null,? ? -> 'isShow' tinyint(1) default 1,? ? -> 'isHot' tinyint(1) default 0,? ? -> 'cId' smallint unsigned not null? ? -> )charset=utf8;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 ''imooc_pro'('id' int unsigned auto_increment key,'pName' varchar(50) not null ' at line 1mysql>mysql> --用戶表? ? -> DROP TABLE EXISTS 'imooc_user';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 '--用 戶表DROP TABLE EXISTS 'imooc_user'' at line 1mysql> CREATE TABLE 'imooc_user'(? ? -> 'id' int unsigned auto_increment key,? ? -> 'username' varchar(20) not null unique,? ? -> 'password' char(32) not null,? ? -> 'sex' enum("男","女","保密") not null default "保密",? ? -> 'face' varchar(50) not null,? ? -> 'regTime' int unsigned not null? ? -> )charset=utf8;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 ''imooc_user'('id' int unsigned auto_increment key,'username' varchar(20) not n' at line 1mysql>mysql> --相冊(cè)表? ? -> DROP TABLE IF EXISTS 'imooc_album';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 '--相 冊(cè)表DROP TABLE IF EXISTS 'imooc_album'' at line 1mysql> CREATE TABLE 'imooc_album'(? ? -> 'id' int unsigned auto_increment key,? ? -> 'pid' int unsigned not null,? ? -> 'albumPass' varchar(50) not null? ? -> )charset=utf8;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 ''imooc_album'('id' int unsigned auto_increment key,'pid' int unsigned not null' at line 1