SqlServer的.sql文件导入mysql应该如何修改

Question

USE [master]GO/****** Object:  Database [yygh_db]    Script Date: 04/16/2015 15:52:19 ******/CREATE DATABASE [yygh_db] ON  PRIMARY ( NAME = N'yygh_db_Data', FILENAME = N'F:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\yygh_db_Data.MDF' , SIZE = 1792KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) LOG ON ( NAME = N'yygh_db_Log', FILENAME = N'F:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\yygh_db_Log.LDF' , SIZE = 2816KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)GOEXEC dbo.sp_dbcmptlevel @dbname=N'yygh_db', @new_cmptlevel=80GOIF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))beginEXEC [yygh_db].[dbo].[sp_fulltext_database] @action = 'disable'endGOALTER DATABASE [yygh_db] SET ANSI_NULL_DEFAULT OFFGOALTER DATABASE [yygh_db] SET ANSI_NULLS OFFGOALTER DATABASE [yygh_db] SET ANSI_PADDING OFFGOALTER DATABASE [yygh_db] SET ANSI_WARNINGS OFFGOALTER DATABASE [yygh_db] SET ARITHABORT OFFGOALTER DATABASE [yygh_db] SET AUTO_CLOSE OFFGOALTER DATABASE [yygh_db] SET AUTO_CREATE_STATISTICS ONGOALTER DATABASE [yygh_db] SET AUTO_SHRINK ONGOALTER DATABASE [yygh_db] SET AUTO_UPDATE_STATISTICS ONGOALTER DATABASE [yygh_db] SET CURSOR_CLOSE_ON_COMMIT OFFGOALTER DATABASE [yygh_db] SET CURSOR_DEFAULT  GLOBALGOALTER DATABASE [yygh_db] SET CONCAT_NULL_YIELDS_NULL OFFGOALTER DATABASE [yygh_db] SET NUMERIC_ROUNDABORT OFFGOALTER DATABASE [yygh_db] SET QUOTED_IDENTIFIER OFFGOALTER DATABASE [yygh_db] SET RECURSIVE_TRIGGERS OFFGOALTER DATABASE [yygh_db] SET  DISABLE_BROKERGOALTER DATABASE [yygh_db] SET AUTO_UPDATE_STATISTICS_ASYNC OFFGOALTER DATABASE [yygh_db] SET DATE_CORRELATION_OPTIMIZATION OFFGOALTER DATABASE [yygh_db] SET TRUSTWORTHY OFFGOALTER DATABASE [yygh_db] SET ALLOW_SNAPSHOT_ISOLATION OFFGOALTER DATABASE [yygh_db] SET PARAMETERIZATION SIMPLEGOALTER DATABASE [yygh_db] SET READ_COMMITTED_SNAPSHOT OFFGOALTER DATABASE [yygh_db] SET  READ_WRITEGOALTER DATABASE [yygh_db] SET RECOVERY SIMPLEGOALTER DATABASE [yygh_db] SET  MULTI_USERGOALTER DATABASE [yygh_db] SET PAGE_VERIFY TORN_PAGE_DETECTIONGOALTER DATABASE [yygh_db] SET DB_CHAINING OFFGOEXEC sys.sp_db_vardecimal_storage_format N'yygh_db', N'ON'GOUSE [yygh_db]GO/****** Object:  Table [dbo].[yyjj]    Script Date: 04/16/2015 15:52:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[yyjj](    [id] [int] IDENTITY(1,1) NOT NULL,    [remark] [text] NULL, CONSTRAINT [PK_yyjj] PRIMARY KEY CLUSTERED (    [id] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET IDENTITY_INSERT [dbo].[yyjj] ONINSERT [dbo].[yyjj] ([id], [remark]) VALUES (1, N'<p>我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院我们是一家三级甲等医院</p>')SET IDENTITY_INSERT [dbo].[yyjj] OFF/****** Object:  Table [dbo].[yy]    Script Date: 04/16/2015 15:52:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[yy](    [id] [int] IDENTITY(1,1) NOT NULL,    [ysid] [varchar](50) NULL,    [rq] [varchar](50) NULL,    [uid] [varchar](50) NULL,    [status] [varchar](50) NULL,    [lsno] [varchar](50) NULL) ON [PRIMARY]GOSET ANSI_PADDING OFFGOSET IDENTITY_INSERT [dbo].[yy] ONINSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (20, N'2', N'2014-05-20', N'2', N'完成', NULL)INSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (18, N'2', N'2014-05-19', N'1', N'完成', NULL)INSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (21, N'3', N'2014-05-21', N'2', N'待诊', NULL)INSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (22, N'2', N'2014-05-20', N'8', N'完成', NULL)INSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (23, N'2', N'2014-05-26', N'1', N'待诊', NULL)INSERT [dbo].[yy] ([id], [ysid], [rq], [uid], [status], [lsno]) VALUES (24, N'2', N'2014-05-26', N'2', N'完成', N'20140525011200')SET IDENTITY_INSERT [dbo].[yy] OFF/****** Object:  Table [dbo].[yspb]    Script Date: 04/16/2015 15:52:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[yspb](    [id] [int] IDENTITY(1,1) NOT NULL,    [rq] [varchar](50) NULL,    [rs] [int] NULL,    [ysid] [varchar](50) NULL, CONSTRAINT [PK_yspb] PRIMARY KEY CLUSTERED (    [id] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOSET IDENTITY_INSERT [dbo].[yspb] ONINSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (1, N'2014-05-19', 5, N'2')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (2, N'2014-05-20', 4, N'2')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (3, N'2014-05-21', 6, N'2')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (4, N'2014-05-19', 2, N'3')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (5, N'2014-05-20', 6, N'3')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (6, N'2014-05-21', 5, N'3')INSERT [dbo].[yspb] ([id], [rq], [rs], [ysid]) VALUES (8, N'2014-05-26', 5, N'2')SET IDENTITY_INSERT [dbo].[yspb] OFF/****** Object:  Table [dbo].[sysuser]    Script Date: 04/16/2015 15:52:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[sysuser](    [id] [int] IDENTITY(1,1) NOT NULL,    [uname] [varchar](50) NULL,    [upass] [varchar](50) NULL,    [tname] [varchar](50) NULL,    [sex] [varchar](50) NULL,    [tel] [varchar](50) NULL,    [ks] [varchar](50) NULL,    [zc] [varchar](50) NULL,    [utype] [varchar](50) NULL,    [img] [varchar](50) NULL,    [delstatus] [varchar](50) NULL,    [idcard] [varchar](50) NULL,    [remark] [text] NULL) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGOSET IDENTITY_INSERT [dbo].[sysuser] ONINSERT [dbo].[sysuser] ([id], [uname], [upass], [tname], [sex], [tel], [ks], [zc], [utype], [img], [delstatus], [idcard], [remark]) VALUES (1, N'admin', N'123', N'管理员', N'男', N'13888888888', N'null', N'null', N'管理员', NULL, N'0', NULL, NULL)INSERT [dbo].[sysuser] ([id], [uname], [upass], [tname], [sex], [tel], [ks], [zc], [utype], [img], [delstatus], [idcard], [remark]) VALUES (2, N'xm', N'123', N'王医生', N'女', N'13333333333', N'3', N'高级', N'医生', N'201405171227540003.jpg', N'0', N'', N'asefawegfaqwe')INSERT [dbo].[sysuser] ([id], [uname], [upass], [tname], [sex], [tel], [ks], [zc], [utype], [img], [delstatus], [idcard], [remark]) VALUES (3, N'xh', N'123', N'陈医生', N'女', N'13512344321', N'3', N'中级', N'医生', N'201405171153350001.jpg', N'0', NULL, NULL)INSERT [dbo].[sysuser] ([id], [uname], [upass], [tname], [sex], [tel], [ks], [zc], [utype], [img], [delstatus], [idcard], [remark]) VALUES (5, N'aa', N'123', N'陈医生', N'男', N'13000000000', N'2', N'初级', N'医生', N'201405192336450002.jpg', N'0', N'1241234234', N'123412341234')INSERT [dbo].[sysuser] ([id], [uname], [upass], [tname], [sex], [tel], [ks], [zc], [utype], [img], [delstatus], [idcard], [remark]) VALUES (6, N'bb', N'123', N'张医生', N'男', N'15512344321', N'4', N'中级', N'医生', N'201405192337440003.jpg', N'0', N'123123123123123123', N'45保护膜')SET IDENTITY_INSERT [dbo].[sysuser] OFF/****** Object:  Table [dbo].[notice]    Script Date: 04/16/2015 15:52:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[notice](    [id] [int] IDENTITY(1,1) NOT NULL,    [title] [varchar](500) NULL,    [content] [text] NULL,    [savetime] [varchar](50) NULL, CONSTRAINT [PK_notice] PRIMARY KEY CLUSTERED (    [id] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGOSET IDENTITY_INSERT [dbo].[notice] ONINSERT [dbo].[notice] ([id], [title], [content], [savetime]) VALUES (2, N'测试新闻一', N'<p>测试新闻一测试新闻一测试新闻一</p>', N'2014-05-18 01:06:37')INSERT [dbo].[notice] ([id], [title], [content], [savetime]) VALUES (3, N'测试新闻二', N'<p>测试新闻二测试新闻二测试新闻二</p>', N'2014-05-18 01:06:44')INSERT [dbo].[notice] ([id], [title], [content], [savetime]) VALUES (4, N'测试新闻三', N'<p>测试新闻三测试新闻三测试新闻三</p>', N'2014-05-19 22:49:39')INSERT [dbo].[notice] ([id], [title], [content], [savetime]) VALUES (5, N'测试新闻四', N'<p>测试新闻四测试新闻四测试新闻四</p>', N'2014-05-19 22:49:45')SET IDENTITY_INSERT [dbo].[notice] OFF/****** Object:  Table [dbo].[ks]    Script Date: 04/16/2015 15:52:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ks](    [id] [int] IDENTITY(1,1) NOT NULL,    [name] [varchar](50) NULL,    [type] [varchar](50) NULL,    [remark] [text] NULL,    [delstatus] [varchar](50) NULL) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGOSET IDENTITY_INSERT [dbo].[ks] ONINSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (2, N'普外门诊', N'外科', N'简介内容，自己去编辑', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (3, N'妇科门诊', N'妇产科', N'简介内容，自己去编辑', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (4, N'儿科门诊', N'儿科', N'简介内容，自己去编辑', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (5, N'眼科门诊', N'眼科', N'简介内容，自己去编辑', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (7, N'耳鼻喉科门诊', N'耳鼻喉科', N'简介内容，自己去编辑', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (8, N'中医科门诊', N'中医科', N'简介内容，自己去编辑', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (9, N'呼吸门诊-肺癌专科门诊', N'内科', N'简介内容，自己去编辑', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (12, N'神经内科', N'内科', N'简介内容，自己去编辑', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (6, N'口腔科门诊', N'口腔科', N'简介内容，自己去编辑', N'0')INSERT [dbo].[ks] ([id], [name], [type], [remark], [delstatus]) VALUES (11, N'皮肤科', N'外科', N'简介内容，自己去编辑', N'0')SET IDENTITY_INSERT [dbo].[ks] OFF/****** Object:  Table [dbo].[br]    Script Date: 04/16/2015 15:52:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[br](    [id] [int] IDENTITY(1,1) NOT NULL,    [uname] [varchar](50) NULL,    [upass] [varchar](50) NULL,    [tname] [varchar](50) NULL,    [age] [varchar](50) NULL,    [sex] [varchar](50) NULL,    [tel] [varchar](50) NULL,    [isblack] [varchar](50) NULL,    [delstatus] [varchar](50) NULL,    [idcard] [varchar](50) NULL) ON [PRIMARY]GOSET ANSI_PADDING OFFGOSET IDENTITY_INSERT [dbo].[br] ONINSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (1, N'vip1', N'123', N'小花', N'40', N'女', N'13555555555', N'no', N'0', N'2451234234456345')INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (2, N'vip2', N'123', N'小陈', N'30', N'男', N'13345665433', N'no', N'0', NULL)INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (3, N'vip3', N'123', N'小王', N'45', N'男', N'13112344321', N'no', N'0', NULL)INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (5, N'vip5', N'123', N'小小', N'33', N'男', N'13765433456', N'no', N'0', NULL)INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (6, N'vip6', N'123', N'笔笔', N'38', N'男', N'13555556666', N'no', N'0', NULL)INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (8, N'calvin', N'123', N'calvin', N'23', N'男', N'13900001166', N'no', N'0', NULL)INSERT [dbo].[br] ([id], [uname], [upass], [tname], [age], [sex], [tel], [isblack], [delstatus], [idcard]) VALUES (7, N'vip4', N'123', N'笔笔', N'44', N'男', N'13555555555', N'no', N'0', NULL)SET IDENTITY_INSERT [dbo].[br] OFF