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

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

/* 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) ...展开详情收缩
2018-07-12 上传大小:11KB
立即下载 开通VIP
分享
收藏 举报
阿蛮歌霸管理歌库 立即下载
2积分/C币
后盾网PHP教学公开课视屏 立即下载
12积分/C币
java异常处理详细介绍 立即下载
3积分/C币
计算机软考数据库系统工程师考前练习300题.doc 立即下载
3积分/C币
数据库sql语句和重要知识点总结 立即下载
3积分/C币
Oracle MySQL SQLite JDBC学习知识点练习源代码 立即下载
3积分/C币
accpY2毕业试题. 立即下载
3积分/C币
简单实用的BBS ASP实现 立即下载
3积分/C币
c++基础知识程序 立即下载
3积分/C币
高一年级信息技术必修ACCESS数据库操作题全部知识点精选 立即下载
3积分/C币
关闭
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和C币套餐优惠
img

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

兑换成功

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

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

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

举报

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

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