不管是在mysql-front还是在phpmyadmin中执行下面的sql语句都报以下错误:
(版本说明:Apache/2.0.63 (Win32) PHP/5.2.6、MYSQL5.1)
SQL 查询:
DROP DATABASE IF EXISTS 'db_shop';
MySQL 返回:
#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 ''db_shop'' at line 1
sql语句如下:DROP DATABASE IF EXISTS 'db_shop';
CREATE DATABASE 'db_shop';
USE 'db_shop';CREATE TABLE admin(
ID int(4) NOT NULL AUTO_INCREMENT,
AdminType int(4) DEFAULT NULL,
AdminName char(12) DEFAULT null,
LoginName char(12) DEFAULT NULL,
LoginPwd char(12) DEFAULT NULL ,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;INSERT into admin(ID,AdminType,AdminName,LoginName,LoginPwd) VALUES (1,1,'商品管理','Admin1','Admin1');
INSERT into admin(ID,AdminType,AdminName,LoginName,LoginPwd) VALUES (2,2,'订单管理','Admin2','Admin2');
INSERT into admin(ID,AdminType,AdminName,LoginName,LoginPwd) VALUES (3,3,'会员管理','Admin3','Admin3');
INSERT into admin(ID,AdminType,AdminName,LoginName,LoginPwd) VALUES (4,4,'系统管理','Admin4','Admin4');CREATE TABLE cart(
ID int(4) NOT NULL AUTO_INCREMENT,
Member int(4) NOT NULL,
Money decimal(9,2) DEFAULT NULL ,
CartStatus int(4) DEFAULT NULL ,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CREATE TABLE cartselectedmer(
ID int(4) NOT NULL AUTO_INCREMENT,
Cart int(4) NOT NULL,
Merchandise int(4) NOT NULL,
Number int(4) NOT NULL DEFAULT 1,
Price decimal(8,2) NOT NULL DEFAULT 0.00,
Money decimal(9,2) NOT NULL DEFAULT 0.00,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE category(
ID int(4) NOT NULL AUTO_INCREMENT,
CateName char(40) DEFAULT NULL ,
CateDesc text ,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE leaveword(
ID int(4) NOT NULL AUTO_INCREMENT,
Menber int(4) NOT NULL ,
Admin int(4) DEFAULT NULL,
Title char(60) DEFAULT NULL,
Content text,
LeaveDate datetime DEFAULT NULL ,
AnswerContent text,
AnswerDate datetime DEFAULT NULL,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE member(
ID int(4) NOT NULL AUTO_INCREMENT,
memberlevel int(4) NOT NULL ,
LoginName char(12) DEFAULT NULL,
LoginPwd char(12) DEFAULT NULL ,
MemberName char(20) DEFAULT NULL,
Phone char(15) DEFAULT NULL ,
Address char(100) DEFAULT NULL,
Zip char(10) DEFAULT NULL ,
RegDate datetime DEFAULT NULL,
LastDate datetime DEFAULT NULL,
LoginTime int(4) DEFAULT NULL,
Email varchar(100) DEFAULT NULL,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE memberlevel(
ID int(4) NOT NULL AUTO_INCREMENT,
LevelName char(20) DEFAULT NULL ,
Favourable int(4) DEFAULT NULL ,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE merchandise(
ID int(4) NOT NULL AUTO_INCREMENT,
Category int(4) NOT NULL,
MerName char(40) DEFAULT NULL ,
Price decimal(8,2) DEFAULT NULL ,
Sprice decimal(8,2) DEFAULT NULL ,
MerModel char(40) DEFAULT NULL ,
Pictrue varchar(100) DEFAULT NULL ,
MerDesc text ,
Manufacturer char(60) DEFAULT NULL ,
LeaveFactoryDate datetime DEFAULT NULL ,
Special int(4) DEFAULT NULL ,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE orders(
ID int(4) NOT NULL AUTO_INCREMENT,
Member int(4) NOT NULL ,
Cart int(4) NOT NULL,
OrderNo char(20) DEFAULT NULL,
OrderDate datetime DEFAULT NULL,
OrderStatus int(4) DEFAULT NULL,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;INSERT into memberlevel(ID,LevelName,Favourable) VALUES (1,'普通会员',90);
INSERT into memberlevel(ID,LevelName,Favourable) VALUES (2,'黄金会员',88);
INSERT into memberlevel(ID,LevelName,Favourable) VALUES (3,'白金会员',87);
INSERT into memberlevel(ID,LevelName,Favourable) VALUES (4,'钻石会员',86),
(版本说明:Apache/2.0.63 (Win32) PHP/5.2.6、MYSQL5.1)
SQL 查询:
DROP DATABASE IF EXISTS 'db_shop';
MySQL 返回:
#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 ''db_shop'' at line 1
sql语句如下:DROP DATABASE IF EXISTS 'db_shop';
CREATE DATABASE 'db_shop';
USE 'db_shop';CREATE TABLE admin(
ID int(4) NOT NULL AUTO_INCREMENT,
AdminType int(4) DEFAULT NULL,
AdminName char(12) DEFAULT null,
LoginName char(12) DEFAULT NULL,
LoginPwd char(12) DEFAULT NULL ,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;INSERT into admin(ID,AdminType,AdminName,LoginName,LoginPwd) VALUES (1,1,'商品管理','Admin1','Admin1');
INSERT into admin(ID,AdminType,AdminName,LoginName,LoginPwd) VALUES (2,2,'订单管理','Admin2','Admin2');
INSERT into admin(ID,AdminType,AdminName,LoginName,LoginPwd) VALUES (3,3,'会员管理','Admin3','Admin3');
INSERT into admin(ID,AdminType,AdminName,LoginName,LoginPwd) VALUES (4,4,'系统管理','Admin4','Admin4');CREATE TABLE cart(
ID int(4) NOT NULL AUTO_INCREMENT,
Member int(4) NOT NULL,
Money decimal(9,2) DEFAULT NULL ,
CartStatus int(4) DEFAULT NULL ,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CREATE TABLE cartselectedmer(
ID int(4) NOT NULL AUTO_INCREMENT,
Cart int(4) NOT NULL,
Merchandise int(4) NOT NULL,
Number int(4) NOT NULL DEFAULT 1,
Price decimal(8,2) NOT NULL DEFAULT 0.00,
Money decimal(9,2) NOT NULL DEFAULT 0.00,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE category(
ID int(4) NOT NULL AUTO_INCREMENT,
CateName char(40) DEFAULT NULL ,
CateDesc text ,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE leaveword(
ID int(4) NOT NULL AUTO_INCREMENT,
Menber int(4) NOT NULL ,
Admin int(4) DEFAULT NULL,
Title char(60) DEFAULT NULL,
Content text,
LeaveDate datetime DEFAULT NULL ,
AnswerContent text,
AnswerDate datetime DEFAULT NULL,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE member(
ID int(4) NOT NULL AUTO_INCREMENT,
memberlevel int(4) NOT NULL ,
LoginName char(12) DEFAULT NULL,
LoginPwd char(12) DEFAULT NULL ,
MemberName char(20) DEFAULT NULL,
Phone char(15) DEFAULT NULL ,
Address char(100) DEFAULT NULL,
Zip char(10) DEFAULT NULL ,
RegDate datetime DEFAULT NULL,
LastDate datetime DEFAULT NULL,
LoginTime int(4) DEFAULT NULL,
Email varchar(100) DEFAULT NULL,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE memberlevel(
ID int(4) NOT NULL AUTO_INCREMENT,
LevelName char(20) DEFAULT NULL ,
Favourable int(4) DEFAULT NULL ,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE merchandise(
ID int(4) NOT NULL AUTO_INCREMENT,
Category int(4) NOT NULL,
MerName char(40) DEFAULT NULL ,
Price decimal(8,2) DEFAULT NULL ,
Sprice decimal(8,2) DEFAULT NULL ,
MerModel char(40) DEFAULT NULL ,
Pictrue varchar(100) DEFAULT NULL ,
MerDesc text ,
Manufacturer char(60) DEFAULT NULL ,
LeaveFactoryDate datetime DEFAULT NULL ,
Special int(4) DEFAULT NULL ,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;CACHE TABLE orders(
ID int(4) NOT NULL AUTO_INCREMENT,
Member int(4) NOT NULL ,
Cart int(4) NOT NULL,
OrderNo char(20) DEFAULT NULL,
OrderDate datetime DEFAULT NULL,
OrderStatus int(4) DEFAULT NULL,
PRIMARY KEY (ID)
) ENGINE =InnoDB DEFAULT CHARSET=gb2312;INSERT into memberlevel(ID,LevelName,Favourable) VALUES (1,'普通会员',90);
INSERT into memberlevel(ID,LevelName,Favourable) VALUES (2,'黄金会员',88);
INSERT into memberlevel(ID,LevelName,Favourable) VALUES (3,'白金会员',87);
INSERT into memberlevel(ID,LevelName,Favourable) VALUES (4,'钻石会员',86),
解决方案 »
- 带输出变量的存储过程调用问题
- 执行这个存储过程怎么没有查出来值呢?我在mysql front下测试无值?
- 求一mysql语句,题目如下:(补充上午的)
- 救命啊,调用存储过程查询数据时MYSQL服务无故自己异常停止
- mysql 插入数据
- 请教: mysql定制问题, 如何定制一个适合软件需求的最小数据库集合
- 紧急请教!提交订单读入数据库为什么这么慢
- 如何再Websphere服务器配置PostgreSQL数据源?
- 如何设置MySQL的自动断开连接时间?
- mysql里面有没有跟SQL SERVER :select top 3 * from member(top) 这样相同的语法啊
- postgresql pg_hba.conf 文件在哪里?
- 求一个SQL语句,谢谢
CREATE DATABASE 'db_shop';
USE 'db_shop';把单引号改成1楼的,或者干脆去掉。
或者'db_shop'-> db_shop