56,679
社区成员
发帖
与我相关
我的任务
分享SQL2012转MYsql
USE [a0113113041]
GO
/****** Object: Table [dbo].[Category] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Category](
[CategoryID] [int] IDENTITY(1,1) NOT NULL,
[Category] [nvarchar](50) NULL,
CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED
(
[CategoryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Color] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Color](
[ColorID] [int] IDENTITY(1,1) NOT NULL,
[Color] [nvarchar](50) NULL,
[CVID] [int] NULL,
CONSTRAINT [PK_Color] PRIMARY KEY CLUSTERED
(
[ColorID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[KC] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KC](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CategoryID] [int] NULL,
[VarietiesID] [int] NULL,
[Type] [nvarchar](50) NULL,
[ColorID] [int] NULL,
[LayerID] [int] NULL,
[ThicknessID] [int] NULL,
[Specification] [nvarchar](50) NULL,
[Meter] [nvarchar](50) NULL,
[Square] [nvarchar](50) NULL,
[Data] [nvarchar](50) NULL,
[Number] [int] NULL,
[Remark] [nvarchar](50) NULL,
[Nmb] [nchar](10) NULL,
CONSTRAINT [PK_KC] 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]
GO
/****** Object: Table [dbo].[Layer] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Layer](
[LayerID] [int] IDENTITY(1,1) NOT NULL,
[Layer] [nvarchar](50) NULL,
[LCID] [int] NULL,
CONSTRAINT [PK_Layer] PRIMARY KEY CLUSTERED
(
[LayerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Thickness] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Thickness](
[ThicknessID] [int] IDENTITY(1,1) NOT NULL,
[Thickness] [nchar](10) NULL,
[TLID] [int] NULL,
CONSTRAINT [PK_Thickness] PRIMARY KEY CLUSTERED
(
[ThicknessID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Varieties] Script Date: 2014/3/31 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Varieties](
[VarietiesID] [int] IDENTITY(1,1) NOT NULL,
[Varieties] [nvarchar](50) NULL,
[VCID] [int] NULL,
CONSTRAINT [PK_Varieties] PRIMARY KEY CLUSTERED
(
[VarietiesID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Color] WITH CHECK ADD CONSTRAINT [FK_Color_Varieties] FOREIGN KEY([CVID])
REFERENCES [dbo].[Varieties] ([VarietiesID])
GO
ALTER TABLE [dbo].[Color] CHECK CONSTRAINT [FK_Color_Varieties]
GO
ALTER TABLE [dbo].[KC] WITH CHECK ADD CONSTRAINT [FK_KC_Category] FOREIGN KEY([CategoryID])
REFERENCES [dbo].[Category] ([CategoryID])
GO
ALTER TABLE [dbo].[KC] CHECK CONSTRAINT [FK_KC_Category]
GO
ALTER TABLE [dbo].[KC] WITH CHECK ADD CONSTRAINT [FK_KC_Color] FOREIGN KEY([ColorID])
REFERENCES [dbo].[Color] ([ColorID])
GO
ALTER TABLE [dbo].[KC] CHECK CONSTRAINT [FK_KC_Color]
GO
ALTER TABLE [dbo].[KC] WITH CHECK ADD CONSTRAINT [FK_KC_Layer] FOREIGN KEY([LayerID])
REFERENCES [dbo].[Layer] ([LayerID])
GO
ALTER TABLE [dbo].[KC] CHECK CONSTRAINT [FK_KC_Layer]
GO
ALTER TABLE [dbo].[KC] WITH CHECK ADD CONSTRAINT [FK_KC_Thickness] FOREIGN KEY([ThicknessID])
REFERENCES [dbo].[Thickness] ([ThicknessID])
GO
ALTER TABLE [dbo].[KC] CHECK CONSTRAINT [FK_KC_Thickness]
GO
ALTER TABLE [dbo].[KC] WITH CHECK ADD CONSTRAINT [FK_KC_Varieties] FOREIGN KEY([VarietiesID])
REFERENCES [dbo].[Varieties] ([VarietiesID])
GO
ALTER TABLE [dbo].[KC] CHECK CONSTRAINT [FK_KC_Varieties]
GO
ALTER TABLE [dbo].[Layer] WITH CHECK ADD CONSTRAINT [FK_Layer_Color] FOREIGN KEY([LCID])
REFERENCES [dbo].[Color] ([ColorID])
GO
ALTER TABLE [dbo].[Layer] CHECK CONSTRAINT [FK_Layer_Color]
GO
ALTER TABLE [dbo].[Thickness] WITH CHECK ADD CONSTRAINT [FK_Thickness_Layer] FOREIGN KEY([ThicknessID])
REFERENCES [dbo].[Layer] ([LayerID])
GO
ALTER TABLE [dbo].[Thickness] CHECK CONSTRAINT [FK_Thickness_Layer]
GO
ALTER TABLE [dbo].[Varieties] WITH CHECK ADD CONSTRAINT [FK_Varieties_Category] FOREIGN KEY([VCID])
REFERENCES [dbo].[Category] ([CategoryID])
GO
ALTER TABLE [dbo].[Varieties] CHECK CONSTRAINT [FK_Varieties_Category]
GO
就这些数据.帮忙转一下.
...全文
请发表友善的回复…
发表回复
benluobo 2014-03-31
- 打赏
- 举报
哪里报错 一个个解决
唐诗三百首 2014-03-31
- 打赏
- 举报
建议转MySQL版本比较好喔.
LongRui888 2014-03-31
- 打赏
- 举报
sql server 和mysql，语法在很多细微的地方都不一样的。
我记得网上有那种，迁移工具，你可以用用的，手动来改，除非你对Mysql 非常熟悉。
1asas 2014-03-31
- 打赏
- 举报
我改了又改，错了又错,实在受不了,求大神帮我改改吧
--小F-- 2014-03-31
- 打赏
- 举报
你的这个脚本里面就是自增列需要注意一下就可以了
在MYSQL里面不是用的IDENTITY
而是用的INCREMENT 其他都差不多 你完全可以自己查查资料搞定
我这里没有MYSQL环境
