下面的.SQL文件导入时出现错误……
#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
go
use 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) --用户积分
)
go
insert into userInfo values('王丽','女','1988-12-17','123456','wansg11li@163.com','11111','1348465094',50000)
insert into userInfo values('刘兴','男','1986-05-17','456123','lsiuddxing@163.com','1111111','1551201463',20000)
insert into userInfo values('刘一','女','1985-05-19','111111','lsiusdxsing@163.com','11111','1584651423',10000)
insert into userInfo values('刘二','男','1986-05-17','456123','liuxfdsfdsfdsfdsing@163.com','1111111','',20000)
insert into userInfo values('二二','','','456123','liuxifdsfdsafng@163.com','11111111111','',20000)
insert into userInfo values('yiyi','','','456123','liuxdfdsfdsfdsfdsing@163.com','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
)
go
insert 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] = 1
select 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 UserIntegral
select * 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 --礼品积分
--)
我的数据库版本是5.0.67 请高手指教,以下是.sql文件内容
use master
go
if exists(select * from sysdatabases where name='ManageDB')
begin
drop database ManageDB
end
create database ManageDB
go
use 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) --用户积分
)
go
insert into userInfo values('王丽','女','1988-12-17','123456','wansg11li@163.com','11111','1348465094',50000)
insert into userInfo values('刘兴','男','1986-05-17','456123','lsiuddxing@163.com','1111111','1551201463',20000)
insert into userInfo values('刘一','女','1985-05-19','111111','lsiusdxsing@163.com','11111','1584651423',10000)
insert into userInfo values('刘二','男','1986-05-17','456123','liuxfdsfdsfdsfdsing@163.com','1111111','',20000)
insert into userInfo values('二二','','','456123','liuxifdsfdsafng@163.com','11111111111','',20000)
insert into userInfo values('yiyi','','','456123','liuxdfdsfdsfdsfdsing@163.com','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
)
go
insert 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] = 1
select 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 UserIntegral
select * 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 --礼品积分
--)
...全文
相关推荐
解决Navicat导入数据库数据结构sql报错datetime(0)的问题
错误发生情况:当你尝试将一个在MySQL 5.7中创建的数据库导出为SQL文件,并试图在MySQL 5.5环境中执行这个SQL文件时,系统可能会报出错误,指出无法识别“datetime(0)”或“timestamp
Navicat导入sql文件
**选择目标数据库**:在左侧对象浏览器中,找到你需要导入SQL文件的数据库,右键点击并选择“运行SQL文件”。3. **选择SQL文件**:在弹出的对话框中,浏览并选择你要导入的.sql文件。4.
SQL Server导入导出数据时最常见的一个错误解决方法
错误的背景是在尝试使用SQL Server导入和导出向导进行数据迁移时,系统报错,指出不能在只读列“ID”中插入数据。
navicat怎么导入sql文件.docx
当我们从一个系统导出数据或结构时,会生成这样的SQL文件,以便在其他地方重新使用这些信息。以下是使用Navicat导入SQL文件的详细步骤:1.
sql server如何导入mdf,ldf文件
"导入SQL Server中的mdf和ldf文件是数据库恢复或迁移过程中常见的操作。mdf文件代表主数据文件,存储了数据库的主要数据和元数据,而ldf文件则是日志文件,记录了所有对数据库的更改操作。



