sql

最新推荐文章于 2024-06-29 12:12:59 发布

Y....

最新推荐文章于 2024-06-29 12:12:59 发布

阅读量142

点赞数

本文链接：https://blog.csdn.net/qq_38606521/article/details/105842506

版权

CREATE TABLE `fly_log` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '记录id',
  `student_id` varchar(50) NOT NULL COMMENT '执飞学员',
  `fly_time` datetime NOT NULL COMMENT '飞行时间',
  `fly_long` int NOT NULL COMMENT '飞行时长',
  `subject` varchar(50) COLLATE utf8_croatian_ci NOT NULL COMMENT '训练科目',
  `result` varchar(255) COLLATE utf8_croatian_ci NOT NULL COMMENT '考核成绩',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

CREATE TABLE `gsp` (
  `id` int NOT NULL COMMENT '人员编号',
  `name` varchar(50) COLLATE utf8_croatian_ci NOT NULL COMMENT '姓名',
  `work_type` varchar(50) COLLATE utf8_croatian_ci NOT NULL COMMENT '工种',
  ` grade` varchar(50) COLLATE utf8_croatian_ci NOT NULL COMMENT '技术等级',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

CREATE TABLE `instructor` (
  `id` int NOT NULL AUTO_INCREMENT,
  `instructor_id` varchar(0) COLLATE utf8_croatian_ci NOT NULL COMMENT '教官编号',
  `name` varchar(50) COLLATE utf8_croatian_ci NOT NULL COMMENT '教官名字',
  `grade` varchar(50) COLLATE utf8_croatian_ci NOT NULL COMMENT '飞行等级',
  `plan_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '执教机型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

CREATE TABLE `plan_info` (
  `id` int NOT NULL,
  `plan_id` varchar(50) COLLATE utf8_croatian_ci NOT NULL COMMENT '飞机编号',
  `name` varchar(50) COLLATE utf8_croatian_ci NOT NULL COMMENT '机型名称',
  `first_time` datetime NOT NULL COMMENT '首飞时间',
  `state` varchar(50) COLLATE utf8_croatian_ci NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;

CREATE TABLE `student` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` varchar(50) COLLATE utf8_croatian_ci NOT NULL COMMENT '学院编号',
  `name` varchar(50) COLLATE utf8_croatian_ci NOT NULL COMMENT '学员名字',
  `birth` date NOT NULL COMMENT '出生日期',
  `plane_id` varchar(50) NOT NULL COMMENT '所学机型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;


INSERT INTO instructor(instructor_id,name,grade,plan_id) VALUE('JG00168','孙平','3级','初教-6');

DELETE FROM plan_info WHERE plan_id = 'F001';

UPDATE student SET name='刘明' WHERE student_id = '191011001';

SELECT * FROM student WHERE name = '张中华';

SELECT *FROM instructor WHERE plane_id = SELECT plane_id FROM student WHERE name = '李成锋';