mod.sql

来自「这是一个网上订票系统」· SQL 代码 · 共 15 行

insert into passenger values('1006','陈一','女','广州市白云区','510785','CA1330');
insert into ticket values('20000001','CA1330','05月26日','08:20','上','陈一','1006','1500','国际航空');
insert into bill values('200001','3U915','陈一','1','1500','1500','大连','国际航空');
insert into speakfor values('20000001','1006');
insert into payment values('1006','200001');

update ticket set startdate='05月27日' where ticketno='20000001';

delete from payment where id='1006';
delete from speakfor where id='1006';
delete from bill where billno='200001';
delete from ticket where ticketno='20000001';
delete from passenger where id='1006';