誰能給看看,哪里出問題了,為什么總是報錯:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual tha
corresponds to your MySQL server version for the right syntax to use near '
--創建數據庫
CREATE DATABASE IF NOT EXISTS`shopImooc`;
--打開數據庫
USE`shopImooc`;
--創建管理員表
DROP TABLE IF EXISTS`imooc_admin`;
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
);
--創建分類表
DROP TABLE IF EXISTS`imooc_cate`;
CREATE TABLE`imooc_cate`(
`id`smallint unsigned auto_increment key,
`cName`varchar(50) unique
);
--創建商品表
DROP TABLE IF EXISTS`imooc_pro`;
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
);
--創建用戶表
DROP TABLE IF EXISTS `imooc_user`;
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
);
--創建相冊表
DROP TABLE IF EXISTS `imooc_album`;
CREATE TABLE `imooc_album`(
`id`int unsigned auto_increment key,
`pid`int unsigned not null,
`albumPath`varchar(50) not null
);
2014-10-15
我也是碰到這個問題,不知怎么解決
2014-09-28
我這里始終不行,下載老師的文件也不行, 難道是運行的時候哪里搞錯了?新人剛學,謝謝你的熱心
2014-09-28
syntax錯誤是語法錯誤,?“right syntax to use near '”near后面是什么?我在控制臺執行了你給出的SQL語句除了“`sex`enum("男","女","保密") not null default "保密",”這句有問題之外,其他一切正常