国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

mysqal作業(yè)

Original 2019-01-15 13:14:48 1010
abstract：/*Navicat MySQL Data TransferSource Server         : ouyangkeSource Server Version : 50553Source Host           : 127.0.0.1:3306Source Database&n

/*

Navicat MySQL Data Transfer


Source Server         : ouyangke

Source Server Version : 50553

Source Host           : 127.0.0.1:3306

Source Database       : ouyangke


Target Server Type    : MYSQL

Target Server Version : 50553

File Encoding         : 65001


Date: 2018-07-26 10:45:32

*/


SET FOREIGN_KEY_CHECKS=0;


-- ----------------------------

-- Table structure for admin

-- ----------------------------

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (

  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理員ID',

  `email` varchar(50) NOT NULL COMMENT '賬號',

  `psword` varchar(32) NOT NULL COMMENT '密碼',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理員表';


-- ----------------------------

-- Records of admin

-- ----------------------------

INSERT INTO `admin` VALUES ('1', 'admin@ouyangke.com', '123456');


-- ----------------------------

-- Table structure for director

-- ----------------------------

DROP TABLE IF EXISTS `director`;

CREATE TABLE `director` (

  `tid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `name` varchar(50) NOT NULL COMMENT '姓名',

  `phone` varchar(20) NOT NULL COMMENT '手機號',

  `country` varchar(20) NOT NULL COMMENT '國家',

  `add_time` int(11) unsigned NOT NULL COMMENT '添加時間',

  PRIMARY KEY (`tid`)

) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='導(dǎo)演表';


-- ----------------------------

-- Records of director

-- ----------------------------

INSERT INTO `director` VALUES ('1', '一本道', '15577774444', '日本', '1531103719');

INSERT INTO `director` VALUES ('2', '東京熱', '16655554444', '日本', '1531103826');

INSERT INTO `director` VALUES ('3', '啄木鳥', '19944441111', '法國', '1531103872');

INSERT INTO `director` VALUES ('4', '宇宙企', '15522223333', '日本', '1531103891');

INSERT INTO `director` VALUES ('5', '桃太郎', '18844441111', '日本', '1531103925');

INSERT INTO `director` VALUES ('6', '鬼畜', '15345645645', '日本', '1531103944');

INSERT INTO `director` VALUES ('7', 'S1', '12299956662', '日本', '1531104091');

INSERT INTO `director` VALUES ('9', '二本道', '122111111111', '日本', '1532425162');

INSERT INTO `director` VALUES ('10', '二本道1', '122111111111', '日本', '1532425172');

INSERT INTO `director` VALUES ('11', '二本到', '122111111111', '日本', '1532425172');


-- ----------------------------

-- Table structure for merge

-- ----------------------------

DROP TABLE IF EXISTS `merge`;

CREATE TABLE `merge` (

  `video_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',

  `video_name` varchar(50) NOT NULL COMMENT '影片名',

  `video_time` date NOT NULL COMMENT '上線時間',

  `director_name` varchar(50) NOT NULL COMMENT '導(dǎo)演名',

  `director_phone` varchar(20) NOT NULL COMMENT '導(dǎo)演電話',

  `director_country` varchar(20) NOT NULL COMMENT '導(dǎo)演國家',

  `user_name` varchar(50) NOT NULL COMMENT '明星名',

  `user_phone` varchar(20) NOT NULL COMMENT '明星名',

  `user_country` varchar(20) NOT NULL COMMENT '演員國家',

  `birthday` date NOT NULL COMMENT '生日',

  `weight` smallint(3) unsigned NOT NULL COMMENT '體重',

  `height` smallint(3) unsigned NOT NULL COMMENT '身高',

  `add_time` datetime NOT NULL COMMENT '添加時間',

  PRIMARY KEY (`video_id`)

) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='合并表';


-- ----------------------------

-- Records of merge

-- ----------------------------

INSERT INTO `merge` VALUES ('1', '天下無碼', '0000-00-00', '', '', '', '小澤', '16644445555', '日本', '1990-07-08', '102', '165', '0000-00-00 00:00:00');

INSERT INTO `merge` VALUES ('2', '天下無碼', '2018-10-10', '一本道', '15500003333', '日本', '波多野結(jié)衣', '18844441111', '日本', '1988-05-05', '98', '170', '2018-08-08 00:00:00');

INSERT INTO `merge` VALUES ('3', '天下無碼', '2018-10-10', '一本道', '15500003333', '日本', '', '', '', '0000-00-00', '0', '0', '2018-08-08 00:00:00');

INSERT INTO `merge` VALUES ('4', '天下無碼', '2018-10-10', '一本道', '15500003333', '日本', '小澤', '16644445555', '日本', '1990-07-08', '102', '165', '2018-08-08 12:00:00');

INSERT INTO `merge` VALUES ('5', '天下無碼', '2018-10-10', '一本道', '15500003333', '日本', '', '', '', '0000-00-00', '0', '0', '2018-08-08 12:00:00');


-- ----------------------------

-- Table structure for user

-- ----------------------------

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

  `uid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '用戶ID',

  `name` varchar(50) NOT NULL COMMENT '姓名',

  `phone` varchar(20) NOT NULL COMMENT '手機號',

  `country` varchar(20) NOT NULL COMMENT '國家',

  `birthday` date NOT NULL COMMENT '生日',

  `weight` smallint(3) unsigned NOT NULL COMMENT '體重',

  `height` smallint(3) unsigned NOT NULL COMMENT '身高',

  `add_time` int(11) unsigned NOT NULL COMMENT '添加時間',

  PRIMARY KEY (`uid`)

) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='明星表';


-- ----------------------------

-- Records of user

-- ----------------------------

INSERT INTO `user` VALUES ('1', '波多野結(jié)衣', '12211112222', '日本', '1988-05-24', '100', '163', '1531104265');

INSERT INTO `user` VALUES ('2', '大橋未久', '14455554444', '日本', '1987-12-24', '98', '158', '1531104315');

INSERT INTO `user` VALUES ('3', '京香', '16644442222', '日本', '1987-05-25', '90', '158', '1531104374');

INSERT INTO `user` VALUES ('4', '麻生希', '19988886666', '日本', '1988-12-20', '102', '170', '1531104407');

INSERT INTO `user` VALUES ('5', '天海翼', '14532147896', '日本', '1988-03-08', '92', '160', '1531104445');

INSERT INTO `user` VALUES ('6', '林由奈', '14512312312', '日本', '1976-11-30', '86', '159', '1531104523');

INSERT INTO `user` VALUES ('7', '小川阿佐美', '19012312345', '日本', '1985-05-11', '96', '167', '1531104606');

INSERT INTO `user` VALUES ('8', '瀨亞美莉', '14465479820', '日本', '1987-09-16', '103', '167', '1531104671');

INSERT INTO `user` VALUES ('9', '原紗央莉', '14501201200', '日本', '1988-01-01', '99', '165', '1531104710');

INSERT INTO `user` VALUES ('10', '柚木提娜', '12345679800', '日本', '1986-10-29', '89', '154', '1531104747');

INSERT INTO `user` VALUES ('11', '早乙女露依', '16578945555', '日本', '1988-06-26', '86', '153', '1531104811');


-- ----------------------------

-- Table structure for video

-- ----------------------------

DROP TABLE IF EXISTS `video`;

CREATE TABLE `video` (

  `video_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '影片ID',

  `video_name` varchar(100) NOT NULL COMMENT '片名',

  `uid` int(11) unsigned NOT NULL COMMENT '明星ID',

  `tid` int(11) unsigned NOT NULL COMMENT '導(dǎo)演ID',

  `release_time` date NOT NULL COMMENT '上映時間',

  `number` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '觀看量',

  `add_time` int(11) unsigned NOT NULL COMMENT '添加時間',

  PRIMARY KEY (`video_id`)

) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='影片表';


-- ----------------------------

-- Records of video

-- ----------------------------

INSERT INTO `video` VALUES ('1', '女老師', '1', '1', '2016-05-04', '100', '1531104951');

INSERT INTO `video` VALUES ('2', '同行愛', '2', '1', '2016-04-01', '200', '1531104974');

INSERT INTO `video` VALUES ('3', '顏物語', '3', '2', '2017-10-22', '600', '1531105003');

INSERT INTO `video` VALUES ('4', '義姉', '3', '4', '2018-02-22', '1000', '1531105108');

INSERT INTO `video` VALUES ('5', '妄想', '4', '4', '2016-08-20', '1110', '1531105159');

INSERT INTO `video` VALUES ('6', '天下無碼', '10', '6', '2018-10-31', '1000', '1532315533');

INSERT INTO `video` VALUES ('8', '鄰家女孩', '10', '3', '2018-10-25', '1000', '1532572221');


Correcting teacher：韋小寶Correction time：2019-01-15 13:20:45
Teacher's summary：你這提交的是啥??？就是sql文件啊 你的作業(yè)呢？作業(yè)講的是利用多表關(guān)系來完成各小案例，那么這中間肯定就需要多表聯(lián)合查詢 你可以先創(chuàng)建兩個數(shù)據(jù)表 這兩個表是關(guān)聯(lián)表 再來通過聯(lián)合查詢對兩表的內(nèi)容進行查詢！課后沒事把這個作業(yè)改一下！

Release Notes

Popular Entries