下载 >  数据库 >  MySQL > 数据库练习(知识点蛮多)

数据库练习(知识点蛮多)

2018-07-12 上传大小:11KB
分享
/*
Navicat SQL Server Data Transfer

Source Server         : .
Source Server Version : 105000
Source Host           : .:1433
Source Database       : testlianxi
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2015-11-10 15:52:19
*/


-- ----------------------------
-- Table structure for cj_t
-- ----------------------------
DROP TABLE [dbo].[cj_t]
GO
CREATE TABLE [dbo].[cj_t] (
[id] int NOT NULL IDENTITY(1,1) ,
[xsid] int NOT NULL ,
[kcid] int NOT
                             NULL ,
[cj] float NOT NULL ,
[t] int NOT NULL 
)


GO

-- ----------------------------
-- Records of cj_t
-- ----------------------------
SET IDENTITY_INSERT [dbo].[cj_t] ON
GO
SET IDENTITY_INSERT [dbo].[cj_t] OFF
GO

-- ----------------------------
-- Table structure for kc_t
-- ----------------------------
DROP TABLE [dbo].[kc_t]
GO
CREATE TABLE [dbo].[kc_t] (
[id] int NOT NULL IDENTITY(1,1) ,
[kcmc] varchar(60) NOT NULL 
)


GO

-- ----------------------------
-- Records of kc_t
-- ----------------------------
SET IDENTITY_INSERT [dbo].[kc_t] ON
GO
SET IDENTITY_INSERT [dbo].[kc_t] OFF
GO

-- ----------------------------
-- Table structure for xs_t
-- ----------------------------
DROP TABLE [dbo].[xs_t]
GO
CREATE TABLE [dbo].[xs_t] (
[id] int NOT NULL IDENTITY(1,1) ,
[xh] varchar(12) NOT NULL ,
[xm] varchar(50) NOT NULL ,
[bj] varchar(20) NOT NULL 
)


GO

-- ----------------------------
-- Records of xs_t
-- ----------------------------
SET IDENTITY_INSERT [dbo].[xs_t] ON
GO
SET IDENTITY_INSERT [dbo].[xs_t] OFF
GO

-- ----------------------------
-- Indexes structure for table cj_t
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table cj_t
-- ----------------------------
ALTER TABLE [dbo].[cj_t] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table kc_t
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table kc_t
-- ----------------------------
ALTER TABLE [dbo].[kc_t] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table xs_t
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table xs_t
-- ----------------------------
ALTER TABLE [dbo].[xs_t] ADD PRIMARY KEY ([id])
GO





INSERT INTO [dbo].[kc_t] ([id], [kcmc]) VALUES (N'1', N'数学')
INSERT INTO [dbo].[kc_t] ([id], [kcmc]) VALUES (N'2', N'英语')
INSERT INTO [dbo].[kc_t] ([id], [kcmc]) VALUES (N'3', N'语文')
INSERT INTO [dbo].[kc_t] ([id], [kcmc]) VALUES (N'4', N'科学')
INSERT INTO [dbo].[kc_t] ([id], [kcmc]) VALUES (N'5', N'政治')
insert into xs_t values('3','Lily','三一班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,55,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,73,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,66,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,75,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,73,1)
insert into xs_t values('1','Tom','三三班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,67,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,62,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,78,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,60,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,72,1)
insert into xs_t values('2','Lisa','三一班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,97,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,76,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,56,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,76,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,71,1)
insert into xs_t values('5','Jim','三二班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,77,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,98,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,58,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,59,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,79,1)
insert into xs_t values('4','Sam','三一班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,91,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,68,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,89,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,68,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,90,1)
insert into xs_t values('6','Jack','三五班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,66,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,90,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,57,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,55,1)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,69,1)
insert into xs_t values('3','Lily','三一班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,86,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,100,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,80,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,99,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,87,2)
insert into xs_t values('1','Tom','三三班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,63,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,64,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,71,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,94,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,62,2)
insert into xs_t values('2','Lisa','三一班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,98,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,63,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,56,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,76,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,84,2)
insert into xs_t values('5','Jim','三二班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,72,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,57,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,93,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,62,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,98,2)
insert into xs_t values('4','Sam','三一班')
insert into cj_t values(IDENT_CURRENT('xs_t'),2,82,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,83,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,95,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,75,2)
insert into xs_t values('6','Jack','三五班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,85,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,87,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,82,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,82,2)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,65,2)
insert into xs_t values('3','Lily','三一班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,96,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,69,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,74,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,81,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,56,3)
insert into xs_t values('1','Tom','三三班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,96,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,92,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,63,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,63,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,83,3)
insert into xs_t values('2','Lisa','三一班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,57,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,80,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,61,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,80,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,64,3)
insert into xs_t values('5','Jim','三二班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,84,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,57,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,90,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,86,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,94,3)
insert into xs_t values('4','Sam','三一班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,95,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,58,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,99,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,61,3)
insert into xs_t values('6','Jack','三五班')
insert into cj_t values(IDENT_CURRENT('xs_t'),1,94,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),2,96,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),3,68,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),4,77,3)
insert into cj_t values(IDENT_CURRENT('xs_t'),5,57,3)                        
...展开收缩
综合评分:0
开通VIP 立即下载

评论共有0条

 
后盾网PHP教学公开课视屏 立即下载
积分/C币:12
java异常处理详细介绍 立即下载
积分/C币:3
计算机软考数据库系统工程师考前练习300题.doc 立即下载
积分/C币:3
数据库知识点大总结 立即下载
积分/C币:10
数据库sql语句和重要知识点总结 立即下载
积分/C币:3
整理后java开发全套达内学习笔记(含练习) 立即下载
积分/C币:3
Oracle MySQL SQLite JDBC学习知识点练习源代码 立即下载
积分/C币:3
accpY2毕业试题. 立即下载
积分/C币:3
简单实用的BBS ASP实现 立即下载
积分/C币:3
数据库MYSQL练习实例 立即下载
积分/C币:5

热点文章

VIP会员动态

推荐下载

数据库知识点
10C币 159下载
数据库练习
5C币 140下载
练习数据库
5C币 140下载
蛮夜色情影院
3C币 17420下载
关闭
img

spring mvc+mybatis+mysql+maven+bootstrap 整合实现增删查改简单实例.zip

资源所需积分/C币 当前拥有积分 当前拥有C币
5 0 0
点击完成任务获取下载码
输入下载码
为了良好体验,不建议使用迅雷下载
img

数据库练习(知识点蛮多)

会员到期时间: 剩余下载个数: 剩余C币: 剩余积分:0
为了良好体验,不建议使用迅雷下载
VIP下载
您今日下载次数已达上限(为了良好下载体验及使用,每位用户24小时之内最多可下载20个资源)

积分不足!

资源所需积分/C币 当前拥有积分
您可以选择
开通VIP
4000万
程序员的必选
600万
绿色安全资源
现在开通
立省522元
或者
购买C币兑换积分 C币抽奖
img

资源所需积分/C币 当前拥有积分 当前拥有C币
5 4 45
为了良好体验,不建议使用迅雷下载
确认下载
img

资源所需积分/C币 当前拥有积分 当前拥有C币
5 0 0
为了良好体验,不建议使用迅雷下载
开通VIP
img

资源所需积分/C币 当前拥有积分 当前拥有C币
5 4 45
您的积分不足,将扣除 10 C币
为了良好体验,不建议使用迅雷下载
确认下载
下载
无法举报自己的资源

兑换成功

你当前的下载分为234开始下载资源
你还不是VIP会员
开通VIP会员权限,免积分下载
立即开通

你下载资源过于频繁,请输入验证码

您因违反CSDN下载频道规则而被锁定帐户,如有疑问,请联络:webmaster@csdn.net!

举报

若举报审核通过,可返还被扣除的积分

  • 举报人:
  • 被举报人:
  • *类型:
    • *投诉人姓名:
    • *投诉人联系方式:
    • *版权证明:
  • *详细原因: