01.
02.
03.
04.
05.
06.
07.
08.
09.
10.SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.CREATE TABLE `tb_job` (
23. `id` int(11) NOT NULL auto_increment,
24. `section` varchar(2) NOT NULL,
25. `team` varchar(1) NOT NULL,
26. `start` varchar(4) NOT NULL,
27. `finish` varchar(4) NOT NULL,
28. PRIMARY KEY (`id`)
29.) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
30.
31.
32.
33.
34.
35.INSERT INTO `tb_job` VALUES (1, '1', 'A', '1200', '1300');
36.INSERT INTO `tb_job` VALUES (2, '2', 'A', '1100', '1500');
37.INSERT INTO `tb_job` VALUES (3, '3', 'A', '1300', '1500');
38.INSERT INTO `tb_job` VALUES (4, '4', 'B', '1000', '1800');
39.INSERT INTO `tb_job` VALUES (5, '5', 'B', '1100', '1400');
40.INSERT INTO `tb_job` VALUES (6, '6', 'B', '1500', '1800');
41.INSERT INTO `tb_job` VALUES (7, '7', 'C', '1400', '1500');
42.INSERT INTO `tb_job` VALUES (8, '8', 'C', '1200', '1600');
43.INSERT INTO `tb_job` VALUES (9, '9', 'C', '1300', '1800');
