MySQL usage & administration 这本书的数据库

最新推荐文章于 2021-03-14 13:16:03 发布
最新推荐文章于 2021-03-14 13:16:03 发布
阅读量573 收藏
点赞数
分类专栏： MySQL 
-- phpMyAdmin SQL Dump
-- version 3.1.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 12, 2009 at 06:14 AM
-- Server version: 5.1.30
-- PHP 

Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET 

@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `db1`
--

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

--
-- Table structure for table `aircraft`
--

DROP TABLE IF EXISTS `aircraft`;
CREATE TABLE `aircraft` (
  

`AircraftID` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
  `AircraftTypeID` smallint(4) unsigned NOT NULL,
  `RegNum` char(6) NOT NULL,
  `LastMaintEnd` date NOT NULL,
  

`NextMaintBegin` date NOT NULL,
  `NextMaintEnd` date NOT NULL,
  PRIMARY KEY (`AircraftID`),
  UNIQUE KEY `RegNum` (`RegNum`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- 

Dumping data for table `aircraft`
--

INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3451, 

503, 'ZX6488', '2007-10-01', '2008-10-23', '2008-10-31');
INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, 

`NextMaintEnd`) VALUES(3465, 503, 'ZX5373', '0000-00-00', '2008-10-14', '2008-10-21');
INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, 

`NextMaintBegin`, `NextMaintEnd`) VALUES(3467, 616, 'ZX7283', '2008-02-05', '2008-12-02', '2008-10-09');
INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, 

`RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3452, 617, 'ZX5464', '2006-10-04', '2009-01-03', '2009-01-21');
INSERT INTO `aircraft` (`AircraftID`, 

`AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3469, 616, 'ZX5382', '2008-04-16', '2009-04-08', '2009-04-18');
INSERT INTO 

`aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3145, 503, 'ZX5731', '2008-04-17', '2009-12-20', '2009-

12-30');
INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3425, 504, 'ZX6821', '2008-06-22', 

'2009-05-25', '2009-06-04');
INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3427, 616, 

'ZX5921', '2008-10-01', '2010-03-02', '2010-04-02');
INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) 

VALUES(3189, 616, 'ZX582', '2008-08-07', '2008-11-05', '2008-11-12');
INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, 

`NextMaintBegin`, `NextMaintEnd`) VALUES(3470, 616, 'ZX5173', '2008-05-20', '2009-10-05', '2009-10-15');
INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, 

`RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3125, 617, 'ZX1386', '2007-12-12', '2009-02-01', '2009-02-22');
INSERT INTO `aircraft` (`AircraftID`, 

`AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3128, 617, 'ZX7634', '2008-03-07', '2009-05-07', '2009-05-18');
INSERT INTO 

`aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3565, 503, 'ZX5830', '2008-11-19', '2009-11-15', '2009-

12-15');
INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3201, 617, 'ZX7472', '2008-10-15', 

'2009-10-15', '2009-10-27');
INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3223, 618, 

'ZX1037', '2008-12-06', '2009-09-16', '2009-09-30');
INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) 

VALUES(3130, 616, 'ZX7391', '2008-09-15', '2009-04-15', '2009-05-15');

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

--
-- Table structure for table 

`aircrafttype`
--

DROP TABLE IF EXISTS `aircrafttype`;
CREATE TABLE `aircrafttype` (
  `AircraftTypeID` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
  `AircraftName` 

varchar(255) NOT NULL,
  PRIMARY KEY (`AircraftTypeID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `aircrafttype`
--

INSERT INTO `aircrafttype` 

(`AircraftTypeID`, `AircraftName`) VALUES(503, 'Boeing 747');
INSERT INTO `aircrafttype` (`AircraftTypeID`, `AircraftName`) VALUES(504, 'Boeing 767');
INSERT INTO 

`aircrafttype` (`AircraftTypeID`, `AircraftName`) VALUES(615, 'Airbus A300/310');
INSERT INTO `aircrafttype` (`AircraftTypeID`, `AircraftName`) VALUES(616, 'Airbus 

A330');
INSERT INTO `aircrafttype` (`AircraftTypeID`, `AircraftName`) VALUES(617, 'Airbus A340');
INSERT INTO `aircrafttype` (`AircraftTypeID`, `AircraftName`) VALUES

(618, 'Airbus A380');

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

--
-- Table structure for table `airport`
--

DROP TABLE IF EXISTS `airport`;
CREATE TABLE 

`airport` (
  `AirportID` smallint(5) unsigned NOT NULL,
  `AirportCode` char(3) NOT NULL,
  `AirportName` varchar(255) NOT NULL,
  `CityName` varchar(255) NOT NULL,
  

`CountryCode` char(2) NOT NULL,
  `NumRunways` tinyint(1) unsigned NOT NULL,
  `NumTerminals` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`AirportID`),
  UNIQUE KEY 

`AirportCode_2` (`AirportCode`),
  KEY `AirportCode` (`AirportCode`),
  KEY `CountryCode` (`CountryCode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table 

`airport`
--

INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(34, 'ORY', 'Orly Airport', 

'Paris', 'FR', 3, 2);
INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(48, 'LGW', 

'Gatwick Airport', 'London', 'UK', 2, 2);
INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) 

VALUES(56, 'LHR', 'Heathrow Airport', 'London', 'UK', 2, 5);
INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, 

`NumTerminals`) VALUES(59, 'CIA', 'Rome Ciampino Airport', 'Rome', 'IT', 1, 1);
INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, 

`CountryCode`, `NumRunways`, `NumTerminals`) VALUES(62, 'AMS', 'Schiphol Airport', 'Amsterdam', 'NL', 6, 1);
INSERT INTO `airport` (`AirportID`, `AirportCode`, 

`AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(72, 'BCN', 'Barcelona International Airport', 'Barcelona', 'ES', 3, 3);
INSERT INTO 

`airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(74, 'MUC', 'Franz Josef Strauss Airport', 

'Munich', 'DE', 3, 2);
INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(83, 'LIS', 

'Lisbon Airport', 'Lisbon', 'PT', 2, 2);
INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) 

VALUES(87, 'BUD', 'Budapest Ferihegy International Airport', 'Budapest', 'HU', 2, 2);
INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, 

`CountryCode`, `NumRunways`, `NumTerminals`) VALUES(92, 'ZRH', 'Zurich Airport ', 'Zurich', 'CH', 3, 1);
INSERT INTO `airport` (`AirportID`, `AirportCode`, 

`AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(126, 'BOM', 'Chhatrapati Shivaji International Airport ', 'Bombay', 'IN', 2, 2);
INSERT 

INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(129, 'BRS', 'Bristol International Airport', 

'Bristol', 'UK', 1, 1);
INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(132, 'MAD', 

'Barajas Airport', 'Madrid', 'ES', 4, 4);
INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) 

VALUES(165, 'NCE', 'Nice Côte d''Azur Airport ', 'Nice', 'FR', 2, 2);
INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, 

`NumRunways`, `NumTerminals`) VALUES(201, 'SIN', 'Changi Airport', 'Singapore', 'SG', 3, 3);

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

--
-- Table 

structure for table `class`
--

DROP TABLE IF EXISTS `class`;
CREATE TABLE `class` (
  `ClassID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` varchar(25) NOT NULL,
  

PRIMARY KEY (`ClassID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `class`
--

INSERT INTO `class` (`ClassID`, `ClassName`) VALUES(1, 'Platinum');
INSERT INTO `class` (`ClassID`, `ClassName`) VALUES(2, 'Gold');
INSERT INTO `class` (`ClassID`, `ClassName`) VALUES(3, 'Silver');

-- 

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

--
-- Table structure for table `flight`
--

DROP TABLE IF EXISTS `flight`;
CREATE TABLE `flight` (
  `FlightID` 

smallint(4) unsigned NOT NULL AUTO_INCREMENT,
  `RouteID` smallint(4) unsigned NOT NULL,
  `AircraftID` smallint(4) unsigned NOT NULL,
  PRIMARY KEY (`FlightID`),
  KEY 

`AircraftID` (`AircraftID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `flight`
--

INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(345, 1003, 3452);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(535, 1005, 3451);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(589, 1097, 3467);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(652, 1018, 3465);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(662, 1018, 3465);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(663, 1009, 3427);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(671, 1169, 3201);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(672, 1169, 3223);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(674, 1165, 3427);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(675, 1023, 3451);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(681, 1123, 3189);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(685, 1180, 3470);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(687, 1191, 3128);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(688, 1139, 3130);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(689, 1140, 3130);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(702, 1008, 3469);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(708, 1006, 3469);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(724, 1193, 3125);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(725, 1192, 3125);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(765, 1133, 3425);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(812, 1190, 3565);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(826, 1209, 3469);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(833, 1061, 3469);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(857, 1059, 3565);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(871, 1173, 3201);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(872, 1173, 3223);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(876, 1175, 3467);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(877, 1176, 3467);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(896, 1141, 3145);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(897, 1142, 3145);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) 

VALUES(898, 1141, 3145);
INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(899, 1142, 3145);

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

--
-- Table structure for table `flightclass`
--

DROP TABLE IF EXISTS `flightclass`;
CREATE TABLE `flightclass` (
  `FlightID` smallint(6) NOT NULL,
  `ClassID` char(1) NOT 

NULL,
  `MaxSeats` smallint(6) NOT NULL,
  `BasePrice` int(11) NOT NULL,
  KEY `ClassID` (`ClassID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table 

`flightclass`
--

INSERT INTO `flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) VALUES(535, '2', 50, 200);
INSERT INTO `flightclass` (`FlightID`, `ClassID`, 

`MaxSeats`, `BasePrice`) VALUES(535, '3', 150, 50);
INSERT INTO `flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) VALUES(876, '2', 85, 250);
INSERT INTO 

`flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) VALUES(876, '3', 100, 35);
INSERT INTO `flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) 

VALUES(876, '1', 10, 300);
INSERT INTO `flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) VALUES(652, '2', 10, 200);
INSERT INTO `flightclass` (`FlightID`, 

`ClassID`, `MaxSeats`, `BasePrice`) VALUES(652, '3', 20, 50);

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

--
-- Table structure for table `flightdep`
--

DROP TABLE IF EXISTS `flightdep`;
CREATE TABLE `flightdep` (
  `FlightID` smallint(6) NOT NULL,
  `DepDay` tinyint(4) NOT NULL,
  `DepTime` time NOT NULL,
  PRIMARY KEY 

(`FlightID`,`DepDay`,`DepTime`),
  KEY `DepDay` (`DepDay`,`DepTime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `flightdep`
--

INSERT INTO 

`flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 1, '21:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 2, '21:30:00');
INSERT 

INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 3, '21:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 4, '21:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 5, '21:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 6, 

'21:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 7, '21:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(535, 

2, '15:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(535, 4, '15:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES

(589, 6, '20:05:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(589, 7, '20:05:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) 

VALUES(652, 1, '14:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(652, 2, '14:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, 

`DepTime`) VALUES(652, 3, '14:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(652, 4, '14:10:00');
INSERT INTO `flightdep` (`FlightID`, 

`DepDay`, `DepTime`) VALUES(652, 5, '14:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(662, 6, '17:45:00');
INSERT INTO `flightdep` 

(`FlightID`, `DepDay`, `DepTime`) VALUES(662, 7, '17:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(663, 1, '09:10:00');
INSERT INTO 

`flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(663, 2, '09:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(663, 3, '09:10:00');
INSERT 

INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(663, 4, '09:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(663, 5, '09:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(671, 1, '16:55:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(671, 3, 

'16:55:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(671, 5, '16:55:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(672, 

2, '16:55:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(672, 4, '16:55:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES

(672, 6, '16:55:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(672, 7, '16:55:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) 

VALUES(674, 1, '14:25:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(674, 2, '14:25:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, 

`DepTime`) VALUES(674, 3, '14:25:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(674, 4, '14:25:00');
INSERT INTO `flightdep` (`FlightID`, 

`DepDay`, `DepTime`) VALUES(675, 1, '07:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(675, 3, '07:30:00');
INSERT INTO `flightdep` 

(`FlightID`, `DepDay`, `DepTime`) VALUES(675, 5, '07:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(681, 1, '08:15:00');
INSERT INTO 

`flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(685, 1, '21:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(685, 2, '21:45:00');
INSERT 

INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(685, 3, '21:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(687, 2, '19:35:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(687, 3, '19:35:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(687, 4, 

'19:35:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(688, 3, '13:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(688, 

4, '13:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(688, 5, '13:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES

(688, 6, '13:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(689, 3, '19:00:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) 

VALUES(689, 4, '19:00:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(689, 5, '19:00:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, 

`DepTime`) VALUES(689, 6, '19:00:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(702, 5, '09:30:00');
INSERT INTO `flightdep` (`FlightID`, 

`DepDay`, `DepTime`) VALUES(702, 6, '09:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(702, 7, '09:30:00');
INSERT INTO `flightdep` 

(`FlightID`, `DepDay`, `DepTime`) VALUES(708, 5, '12:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(708, 6, '12:45:00');
INSERT INTO 

`flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(708, 7, '12:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(724, 3, '23:30:00');
INSERT 

INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(724, 7, '23:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(725, 1, '17:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(725, 4, '17:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(765, 2, 

'01:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(765, 4, '01:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(765, 

6, '01:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(812, 1, '14:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES

(812, 2, '14:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(812, 3, '14:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) 

VALUES(812, 4, '14:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(812, 5, '14:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, 

`DepTime`) VALUES(826, 2, '13:45:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(833, 3, '07:00:00');
INSERT INTO `flightdep` (`FlightID`, 

`DepDay`, `DepTime`) VALUES(857, 1, '19:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(857, 2, '19:30:00');
INSERT INTO `flightdep` 

(`FlightID`, `DepDay`, `DepTime`) VALUES(857, 3, '19:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(857, 4, '19:30:00');
INSERT INTO 

`flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(857, 5, '19:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(871, 1, '12:50:00');
INSERT 

INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(871, 3, '12:50:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(871, 5, '12:50:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(872, 2, '12:50:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(872, 4, 

'12:50:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(872, 6, '12:50:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(872, 

7, '12:50:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(876, 1, '07:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES

(876, 2, '07:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(876, 3, '07:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) 

VALUES(876, 4, '07:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(876, 5, '07:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, 

`DepTime`) VALUES(877, 1, '20:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(877, 2, '20:30:00');
INSERT INTO `flightdep` (`FlightID`, 

`DepDay`, `DepTime`) VALUES(877, 3, '20:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(877, 4, '20:30:00');
INSERT INTO `flightdep` 

(`FlightID`, `DepDay`, `DepTime`) VALUES(877, 5, '20:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(896, 1, '00:30:00');
INSERT INTO 

`flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(896, 2, '00:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(896, 3, '00:30:00');
INSERT 

INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(896, 6, '00:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(896, 7, '00:30:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(897, 1, '20:15:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(897, 2, 

'20:15:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(897, 3, '20:15:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(897, 

6, '20:15:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(897, 7, '20:15:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES

(898, 4, '00:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(898, 5, '00:10:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) 

VALUES(899, 4, '21:15:00');
INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(899, 5, '21:15:00');

-- 

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

--
-- Table structure for table `log`
--

DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `RecordID` int(11) NOT 

NULL AUTO_INCREMENT,
  `ByUser` varchar(50) NOT NULL,
  `Note` text NOT NULL,
  `EventTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  

PRIMARY KEY (`RecordID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `log`
--


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

--
-- Table 

structure for table `pax`
--

DROP TABLE IF EXISTS `pax`;
CREATE TABLE `pax` (
  `RecordID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `FlightID` int(11) NOT NULL,
  

`FlightDate` date NOT NULL,
  `ClassID` int(11) NOT NULL,
  `PaxName` varchar(255) NOT NULL,
  `PaxRef` varchar(255) DEFAULT NULL,
  `Note` text,
  PRIMARY KEY 

(`RecordID`),
  KEY `ClassID` (`ClassID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pax`
--

INSERT INTO `pax` (`RecordID`, `FlightID`, 

`FlightDate`, `ClassID`, `PaxName`, `PaxRef`, `Note`) VALUES(197, 652, '2009-01-20', 2, 'Henry Rabbit', 'TG75850303', '');
INSERT INTO `pax` (`RecordID`, `FlightID`, 

`FlightDate`, `ClassID`, `PaxName`, `PaxRef`, `Note`) VALUES(198, 652, '2009-01-20', 3, 'Harry Hippo', 'TG75847493', '');
INSERT INTO `pax` (`RecordID`, `FlightID`, 

`FlightDate`, `ClassID`, `PaxName`, `PaxRef`, `Note`) VALUES(199, 652, '2009-01-20', 3, 'Henrietta Hippo', 'TG75847493', '');

-- 

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

--
-- Table structure for table `route`
--

DROP TABLE IF EXISTS `route`;
CREATE TABLE `route` (
  `RouteID` 

smallint(4) unsigned NOT NULL AUTO_INCREMENT,
  `From` smallint(4) unsigned NOT NULL,
  `To` smallint(4) unsigned NOT NULL,
  `Distance` smallint(4) unsigned NOT NULL,
  

`Duration` smallint(4) unsigned NOT NULL,
  `Status` tinyint(1) NOT NULL,
  PRIMARY KEY (`RouteID`),
  KEY `Duration` (`Duration`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `route`
--

INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1003, 126, 56, 7200, 550, 1);
INSERT INTO 

`route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1005, 34, 48, 343, 85, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, 

`Duration`, `Status`) VALUES(1176, 56, 132, 1267, 150, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1175, 132, 56, 1267, 

150, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1018, 34, 87, 1248, 135, 1);
INSERT INTO `route` (`RouteID`, `From`, 

`To`, `Distance`, `Duration`, `Status`) VALUES(1023, 48, 59, 1434, 150, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1008, 

34, 165, 686, 60, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1009, 34, 92, 489, 70, 1);
INSERT INTO `route` (`RouteID`, 

`From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1165, 92, 59, 683, 50, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) 

VALUES(1167, 92, 56, 777, 70, 0);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1123, 92, 48, 777, 60, 1);
INSERT INTO `route` 

(`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1133, 74, 126, 6336, 470, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, 

`Status`) VALUES(1141, 126, 201, 3913, 320, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1142, 201, 126, 3915, 320, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1180, 201, 56, 10863, 815, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, 

`Distance`, `Duration`, `Status`) VALUES(1193, 201, 92, 10310, 760, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1191, 74, 

83, 1966, 190, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1071, 132, 72, 505, 65, 0);
INSERT INTO `route` (`RouteID`, 

`From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1190, 72, 165, 488, 80, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) 

VALUES(1173, 72, 62, 1237, 130, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1169, 62, 92, 612, 120, 1);
INSERT INTO 

`route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1139, 83, 87, 2474, 150, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, 

`Duration`, `Status`) VALUES(1140, 87, 83, 2474, 150, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1097, 129, 165, 1134, 

120, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1209, 56, 59, 1434, 150, 1);
INSERT INTO `route` (`RouteID`, `From`, 

`To`, `Distance`, `Duration`, `Status`) VALUES(1006, 165, 132, 974, 125, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES

(1059, 165, 62, 978, 130, 1);
INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1061, 48, 87, 1452, 155, 1);
INSERT INTO `route` 

(`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1192, 92, 201, 10310, 760, 0);

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

--
-- Table 

structure for table `stats`
--

DROP TABLE IF EXISTS `stats`;
CREATE TABLE `stats` (
  `FlightID` int(11) NOT NULL,
  `FlightDate` date NOT NULL,
  `ClassID` int(11) NOT 

NULL,
  `CurrSeats` int(11) NOT NULL,
  `CurrPrice` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stats`
--

INSERT INTO `stats` 

(`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(652, '2009-01-20', 2, 9, 200);
INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, 

`CurrSeats`, `CurrPrice`) VALUES(652, '2009-01-20', 3, 17, 50);
INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(876, '2009-

04-01', 1, 10, 300);
INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(876, '2009-04-01', 2, 85, 250);
INSERT INTO `stats` 

(`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(876, '2009-04-01', 3, 100, 35);
INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, 

`CurrSeats`, `CurrPrice`) VALUES(876, '2009-04-08', 1, 3, 300);
INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(876, '2009-

04-08', 2, 3, 250);
INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(876, '2009-04-08', 3, 3, 35);
本书网站： http://www.mysql-usage.com/book.html
刘利新西安
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
MySQL Database Usage & Administration_MYSQL_
10-03
MySQL Database Usage & Administration
MySql-Administration
11-27
一款非常好用的官方的MySQL管理工具!
MySQL Server Administration
linvar
04-16 144
[size=medium] [b]1.Server Option and Variable Reference[/b] 1).SHOW [GLOBAL | SESSION] STATUS 2).Show collation; 3).show variables like '%...%' [b]2.Server Response to Signals[/...
mysql administration_MYSQL administrator 使用
weixin_36444661的博客
01-19 428
MYSQL administrator 使用更新时间：2008年06月30日 22:01:49 作者：Administrator也许你认为可以不需要这个东西，但我还是要建议你下载并使用MySQL Administrator，它提供图形界面以帮助你管理MySQL数据库，Windows用户可以通过命令提示行运行MySQLAdministrator，在余下时间里我假定你已经安装了MySQLAdmi...
nginx使用、注册服务项
pentiumCM的博客
02-07 1995
nginx 使用、注册服务项
腾讯云数据库mysql产品认证答案
11-14
腾讯云数据库mysql产品认证答案涵盖了mysql数据库、腾讯云、云数据库、mysql数据库认证和腾讯云云数据库产品等方面的知识点，是一份非常重要的认证考试答案，能够帮助考生更好地掌握mysql数据库管理和维护知识。
Mysql数据库实战教程&案例&相关项目
05-01
MySQL数据库作为一个广泛使用的开源关系型数据库管理系统，它在Web开发、数据管理和企业级应用中扮演着重要角色。以下是对MySQL数据库实战教程、案例及相关项目的描述： MySQL数据库实战教程： 教程目的：教程旨在...
Mysql数据库实战教程&案例&相关项目【l数据库实战】
05-06
总的来说，通过这门“MySQL数据库实战教程&案例&相关项目”，你不仅能学到丰富的理论知识，还能在实践中提高解决问题的能力，为未来在数据库领域的工作打下坚实的基础。记得持续学习，因为数据库技术总是在不断发展...
Oracle&Mysql;&Sql; Server数据库JDBC驱动包
03-20
包含：sqljdbc42.jar 微软Sql Server 数据库驱动 ojdbc6.jar Oracle数据库驱动 mysql-connector-java-5.1.20-bin.jar Mysql驱动
红帽下卸载mysql
weixin_30436101的博客
10-05 223
红帽下卸载mysql1、查找以前是否装有mysql 命令：rpm -qa|grep -i mysql 可以看到mysql的两个包： mysql-*..*.RHEL** mysqlclient*.RHEL** 2、删除mysql 删除命令：rpm -e --nodeps 包名 ( rpm -ev mysql-*.RHEL* ) 3、删除老版本mysql的开发头文件和库 命令：rm ...
mysql administration_Mysql---MySQL Server Administration
weixin_33402252的博客
01-19 185
1、The Mysql Servermysqld is the MySQL server.1.1、Configuring the Servera，查看Mysql Server options and configurable system variablesmysqld --verbose --helpb，查看当前正在运行的 Mysql Server实例 system variable value...
MySQL学习笔记2-System administration（STOP or START MySQL）
bruce
11-17 406
START MYSQL [root@localhost bin]# service mysql start Starting MySQL.. SUCCESS!  [root@localhost bin]# ps -ef | grep mysql root      5548     1  0 22:00 pts/2    00:00:00 /bin/sh /usr/bin/mysqld_s
start and stop mysql_MySQL学习笔记2-System administration（STOP or START MySQL）
weixin_28842269的博客
02-11 95
START MYSQL[root@localhost bin]# service mysql startStarting MySQL.. SUCCESS![root@localhost bin]# ps -ef | grep mysqlroot 5548 1 0 22:00 pts/2 00:00:00 /bin/sh /usr/bin/mysqld_safe --dat...
mysql-administrator的安装与使用
xuan_oscar的专栏
04-13 7995
2007-04-07 07:34mysql-administrator的安装与使用（图文）  ● 准备工作在D盘建立一个mysql-software的目录，把刚才下载的 mysql-administrator-1.0.19-win-noinstall.zip 复制到这个子目录中，解压，得到一个 MySQL Administrator 1.0 的目录。同样如此操作 mysql-q
MySQL数据库笔记（一）
Y_zpqq的博客
03-14 213
MySQL数据库官网地址 www.mysql.com 数据库结构 1.数据库系统 DBS A. 数据库管理系统(DataBase Management System， DBMS): SQL(RDS 关系型数据库) ​ ORACLE ​ Oracle MySql ​ DB2(IBM) ​ SQL-Server(MS) ​ MySql ​ Ma
“人力资源+大数据+薪酬报告+涨薪调薪”
08-12
人力资源+大数据+薪酬报告+涨薪调薪，在学习、工作生活中，越来越多的事务都会使用到报告，通常情况下，报告的内容含量大、篇幅较长。那么什么样的薪酬报告才是有效的呢？以下是小编精心整理的调薪申请报告，欢迎大家分享。相信老板看到这样的报告，一定会考虑涨薪的哦。
深度报告-20231012-东海证券-电力设备与新能源行业深度报告-长时储能东风起-钒电需求待腾飞-42页-3mb.pdf
08-12
深度报告-20231012-东海证券-电力设备与新能源行业深度报告_长时储能东风起_钒电需求待腾飞_42页_3mb.pdf
基于Python+JavaScript实现的联邦学习网站系统源码+文档说明(高分毕业设计)
最新发布
08-12
<项目介绍> 毕设 前端： React-Hook Material UI axios请求数据 token头请求验证 Echarts图可视化 后端： Django框架 写API运行算法传数据 在本系统中，用户通过邮箱注册后登录进入首页，可以通过导航栏快速跳转到实验设置，实验过程，实验数据查看和退出登录等，也可以通过侧边栏来选择算法进行实验，点击不同的 - 不懂运行，下载完可以私聊问，可远程教学 该资源内项目源码是个人的毕设，代码都测试ok，都是运行成功后才上传资源，答辩评审平均分达到96分，放心下载使用！ 1、该资源内项目代码都经过测试运行成功，功能ok的情况下才上传的，请放心下载使用！ 2、本项目适合计算机相关专业(如计科、人工智能、通信工程、自动化、电子信息等)的在校学生、老师或者企业员工下载学习，也适合小白学习进阶，当然也可作为毕设项目、课程设计、作业、项目初期立项演示等。 3、如果基础还行，也可在此代码基础上进行修改，以实现其他功能，也可用于毕设、课设、作业等。 下载后请首先打开README.md文件（如有），仅供学习参考, 切勿用于商业用途。 --------
Java & MySQL实现的学生管理数据库系统
"数据库学生管理系统是一个使用Java编程语言和MySQL数据库技术实现的教学管理平台。该系统包含权限管理，如区分教师和学生角色，以及基本的数据操作功能，如增删改查。系统设计遵循数据库设计规范，力求降低数据冗余...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值