Destination NVarChar (50), FlightStatus NVarChar(50),
ArrivalDate DATETIME, FlownMiles INTEGER);INSERT INTO
MembershipData (MemberName) VALUES ('Mr Don
Hall');INSERT INTO MembershipData (MemberName) VALUES
('Mr Jon Morris');INSERT INTO MembershipData
(MemberName) VALUES ('Ms TiAnna Jones');INSERT INTO
FlightData (MemberID, Destination, FlightStatus,
ArrivalDate, FlownMiles) VALUES (1, 'Seattle', 'Flight
Delayed 1 hour', '8/25/00', '20000');INSERT INTO
FlightData (MemberID, Destination, FlightStatus,
ArrivalDate, FlownMiles) VALUES (2, 'London', 'Flight
on time', '9/12/00', '15000');INSERT INTO FlightData
(MemberID, Destination, FlightStatus, ArrivalDate,
FlownMiles) VALUES (3, 'Sydney', 'Flight Gate
Closing', '11/5/00', '30000');INSERT INTO FlightData
(MemberID, Destination, FlightStatus, ArrivalDate,
FlownMiles) VALUES (1, 'Tokyo', 'Delayed Fog',
'5/25/00', '25000');INSERT INTO FlightData (MemberID,
Destination, FlightStatus, ArrivalDate, FlownMiles)
VALUES (2, 'Minneapolis', 'Flight on time', '5/1/00',
'1000');INSERT INTO FlightData (MemberID,
Destination, FlightStatus, ArrivalDate, FlownMiles)
VALUES (3, 'Memphis', 'Flight Gate Closing', '1/5/00',
'1000');
4. 单击“执行(!)”运行该脚本并创建数据库。
评论0
最新资源