#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 'go if exists(select * from sysdatabases where name='ManageDB') begin drop da' at line 2我的数据库版本是5.0.67 请高手指教,以下是.sql文件内容
use master
go
if exists(select * from sysdatabases where name='ManageDB')
begin
drop database ManageDB
end
create database ManageDB
gouse ManageDB
go
--------用户信息--------------
create table userInfo
(
UserId int primary key identity(1,1) , --用户id
UserName varchar(10) not null, --用户名
Gender varchar(4) default '女', --用户性别
UserBirthday datetime , --用户生日
UserPwd varchar(10) , --用户密码
UserEmail varchar(20) , --用户邮件
UserCity varchar(50), --用户所在城市
UserPhone varchar(20),
UserIntegral int default(0) --用户积分
)
goinsert into userInfo values('王丽','女','1988-12-17','123456','[email protected]','11111','1348465094',50000)
insert into userInfo values('刘兴','男','1986-05-17','456123','[email protected]','1111111','1551201463',20000)
insert into userInfo values('刘一','女','1985-05-19','111111','[email protected]','11111','1584651423',10000)
insert into userInfo values('刘二','男','1986-05-17','456123','[email protected]','1111111','',20000)
insert into userInfo values('二二','','','456123','[email protected]','11111111111','',20000)
insert into userInfo values('yiyi','','','456123','[email protected]','11111111111111111','',0)select * from userInfo
--------礼品信息--------------create table GiftsInfo
(
GiftsId int primary key identity(1,1) ,
UserId int foreign key references userInfo(UserId) ,
GiftsName varchar(20) not null,
GiftsIntegral int default(0) not null,
GiftsImg varchar(20) not null
)
goinsert into GiftsInfo values(1,'热水杯',1300,'a.jpg')
insert into GiftsInfo values(1,'克',1000,'a.jpg')
insert into GiftsInfo values(1,'小克',1500,'a.jpg')
insert into GiftsInfo values(2,'热水杯',1300,'a.jpg')
insert into GiftsInfo values(2,'克',1000,'a.jpg')
insert into GiftsInfo values(3,'小快克',1500,'a.jpg')
insert into GiftsInfo values(3,'水杯',1300,'a.jpg')
insert into GiftsInfo values(4,'克',1000,'a.jpg')
insert into GiftsInfo values(4,'小克',1500,'a.jpg')select * from GiftsInfo
--------最新礼品信息--------------
create table NewsGifts
(
NGId int primary key identity(1,1),
NGName varchar(20) ,
NGIntegral int ,
NGImg varchar(100)
)
go
insert into Newsgifts values('11111111111111',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('11111111111111',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('11111111111111',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('彩11111111111111',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('11111111111111伞',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('fdsfds伞',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('dfsdsfd',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('fdsfds',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('dfsfdsf',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('fdsfdsfds',1000,'a.gif')
select * from NewsGifts---------------------------------------------------------------------------------------
--declare @UserIntegral
--update userInfo set UserIntegral= 10000 where [UserId] = 1select convert(char(10),UserBirthday,120) as 'UserBirthday' from UserInfo
---------------------------------------------------------------------------------------select Username,Gender,UserEmail,UserCity,UserIntegral,convert(char(10),UserBirthday,120) as 'UserBirthday' from UserInfo
---------------------------------------------------------------------------------------create table UserIntegral
(
Integral_Id int foreign key references userInfo(UserID) identity(1,1),
Integral_Users int
)
go
insert into UserIntegral values(50000)
insert into UserIntegral values(20000)
select * from UserIntegralselect * from userInfo as a join userIntegral as b on a.UserId=b.Integral_Id
--create table GiftsInfo
--(
--giftsId int primary key identity(1,1) not null, --礼品编号
--giftsName varchar(50) not null,
--
--giftsIntegral int not null --礼品积分
--)
use master
go
if exists(select * from sysdatabases where name='ManageDB')
begin
drop database ManageDB
end
create database ManageDB
gouse ManageDB
go
--------用户信息--------------
create table userInfo
(
UserId int primary key identity(1,1) , --用户id
UserName varchar(10) not null, --用户名
Gender varchar(4) default '女', --用户性别
UserBirthday datetime , --用户生日
UserPwd varchar(10) , --用户密码
UserEmail varchar(20) , --用户邮件
UserCity varchar(50), --用户所在城市
UserPhone varchar(20),
UserIntegral int default(0) --用户积分
)
goinsert into userInfo values('王丽','女','1988-12-17','123456','[email protected]','11111','1348465094',50000)
insert into userInfo values('刘兴','男','1986-05-17','456123','[email protected]','1111111','1551201463',20000)
insert into userInfo values('刘一','女','1985-05-19','111111','[email protected]','11111','1584651423',10000)
insert into userInfo values('刘二','男','1986-05-17','456123','[email protected]','1111111','',20000)
insert into userInfo values('二二','','','456123','[email protected]','11111111111','',20000)
insert into userInfo values('yiyi','','','456123','[email protected]','11111111111111111','',0)select * from userInfo
--------礼品信息--------------create table GiftsInfo
(
GiftsId int primary key identity(1,1) ,
UserId int foreign key references userInfo(UserId) ,
GiftsName varchar(20) not null,
GiftsIntegral int default(0) not null,
GiftsImg varchar(20) not null
)
goinsert into GiftsInfo values(1,'热水杯',1300,'a.jpg')
insert into GiftsInfo values(1,'克',1000,'a.jpg')
insert into GiftsInfo values(1,'小克',1500,'a.jpg')
insert into GiftsInfo values(2,'热水杯',1300,'a.jpg')
insert into GiftsInfo values(2,'克',1000,'a.jpg')
insert into GiftsInfo values(3,'小快克',1500,'a.jpg')
insert into GiftsInfo values(3,'水杯',1300,'a.jpg')
insert into GiftsInfo values(4,'克',1000,'a.jpg')
insert into GiftsInfo values(4,'小克',1500,'a.jpg')select * from GiftsInfo
--------最新礼品信息--------------
create table NewsGifts
(
NGId int primary key identity(1,1),
NGName varchar(20) ,
NGIntegral int ,
NGImg varchar(100)
)
go
insert into Newsgifts values('11111111111111',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('11111111111111',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('11111111111111',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('彩11111111111111',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('11111111111111伞',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('fdsfds伞',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('dfsdsfd',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('fdsfds',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('dfsfdsf',1233,'~/images/mem/lp_thub.gif')
insert into Newsgifts values('fdsfdsfds',1000,'a.gif')
select * from NewsGifts---------------------------------------------------------------------------------------
--declare @UserIntegral
--update userInfo set UserIntegral= 10000 where [UserId] = 1select convert(char(10),UserBirthday,120) as 'UserBirthday' from UserInfo
---------------------------------------------------------------------------------------select Username,Gender,UserEmail,UserCity,UserIntegral,convert(char(10),UserBirthday,120) as 'UserBirthday' from UserInfo
---------------------------------------------------------------------------------------create table UserIntegral
(
Integral_Id int foreign key references userInfo(UserID) identity(1,1),
Integral_Users int
)
go
insert into UserIntegral values(50000)
insert into UserIntegral values(20000)
select * from UserIntegralselect * from userInfo as a join userIntegral as b on a.UserId=b.Integral_Id
--create table GiftsInfo
--(
--giftsId int primary key identity(1,1) not null, --礼品编号
--giftsName varchar(50) not null,
--
--giftsIntegral int not null --礼品积分
--)
错误
SQL 查询: USE MASTER ;MySQL 返回: #1049 - Unknown database 'master'
master这个数据库应该是SQL SERVER的系统数据库,MYSQL并没有,应该要去掉
go
if exists(select * from sysdatabases where name='ManageDB')
begin
drop database ManageDB
end
create database ManageDB
gouse ManageDB
go
这些内容,替换为:DROP DATABASE IF EXISTS `ManageDB`;
CREATE DATABASE `ManageDB` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ManageDB`;