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
就这些数据.帮忙转一下.
相关推荐
必须详细与全面的Java开发环境搭建图文教程
本篇文章内容包括:Linux理论与实操,MySQL实操,JDK实操,Tomcat实操和Tomcat实操,需要的朋友可以参考下
10.网站设计与开发项目技能竞赛技术方案.pdf
10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf10.网站设计与开发项目技能竞赛技术方案.pdf
sqlserver向mysql迁移
本文描述了SqlServer向mysql迁移的要领以及规则
C#实现连接SQL Server2012数据库并执行SQL语句的方法
主要介绍了C#实现连接SQL Server2012数据库并执行SQL语句的方法,结合实例形式较为详细的分析了C#连接SQL Server2012数据库并执行查询、插入等操作的相关实现技巧,需要的朋友可以参考下
SQL Server2012数据库备份和还原的教程
一、数据库的备份 1、选择要备份的数据库“accountInfo”,点击鼠标右键 → 任务 → 备份 2、在打开的“备份数据库 —accountInfo”对话框中,先点击删除,然后点击“添加” 3、在弹出的“选择备份目标”对话框中选择好路径和备份的文件名 4、之后在备份数据库窗口点击确定,等待备份成功 二、数据库的还原 1、在对象资源管理器中右键单击【数据库】-【还原数据库】 2、在弹出的【还原数据库】窗口,选择【设备】,并点击右侧的【…】;在弹出的【选择备份设备】窗口,点击【添加】,找到备份的文件;在【还原数据库】窗口中【目标-数据库】处输入数据库名称,并单击【确定】。 3、等


