建立数据库student2和表stu-info,grade-info
USE [student2]
GO
/****** 对象: Table [dbo].[stu_info] 脚本日期: 05/19/2015 23:32:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[stu_info](
[NO] [varchar](200) NOT NULL,
[name] [varchar](200) NULL,
[class] [int] NULL,
CONSTRAINT [PK_stu_info] PRIMARY KEY CLUSTERED
(
[NO] 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
SET ANSI_PADDING OFF
USE [student2]
GO
/****** 对象: Table [dbo].[grade_info] 脚本日期: 05/19/2015 23:32:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[grade_info](
[NO] [varchar](200) NULL,
[name] [varchar](200) NULL,
[times] [int] NULL,
[grade] [int] NOT NULL CONSTRAINT [DF_grade_info_grade] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
结果显示
建立数据库student2
建立表stu-info
建立表grade-info
导入excel文件进数据库的表
用mysql语句查询出结果