CREATE DATABASE flightlog;

USE flightlog;

SELECT DATABASE();

CREATE TABLE flightsessions (flight_date DATE, flight_time TIME, origin VARCHAR(45), destination VARCHAR(45),
weather VARCHAR(45), winds VARCHAR(45), temp INTEGER);

DESCRIBE flightsessions;

INSERT INTO flightsessions VALUES('2007-02-04', '01:30:00', 'Sonoma', 'Sonoma', 'Sunny', 'W 10 MPH', 58);

SELECT * FROM flightsessions;

INSERT INTO flightsessions VALUES('2007-02-15', '02:15:00', 'Sonoma', 'Lake Tahoe', 'Partly cloudy', 'E 8 MPH', 62);

SELECT * FROM flightsessions;

LOAD DATA LOCAL INFILE 'C:/flights.txt' INTO TABLE flightsessions;

SELECT * FROM flightsessions;

SELECT flight_date, origin, destination FROM flightsessions;

SELECT flight_date, origin, destination FROM flightsessions ORDER BY origin, destination;

SELECT flight_date, origin, destination FROM flightsessions ORDER BY flight_date DESC;

SELECT * FROM flightsessions WHERE origin='Sonoma';

SELECT * FROM flightsessions WHERE temp>60;

UPDATE flightsessions SET origin='San Luis Obispo' WHERE origin='Santa Barbara';

UPDATE flightsessions SET destination='San Luis Obispo' WHERE destination='Santa Barbara';

SELECT * FROM flightsessions;

DELETE FROM flightsessions WHERE flight_date='2007-02-04' and flight_time='01:30:00';

DROP TABLE flightlog;

DROP DATABASE flightlog;