汽車站數(shù)據(jù)庫設(shè)計(jì)-資料下載頁
2025-06-30 05:40本頁面
【正文】 9。)。insert into car_line (carID,lineID) values (39。9120339。,39。20100639。)。insert into car_line (carID,lineID) values (39。9120239。,39。20100339。)。insert into car_line (carID,lineID) values (39。9120639。,39。20100639。)。insert into user_ID values(39。邱冬39。,39。12345639。)。：建立索引遵循的規(guī)律：，create index car_index on car(car_ID)。汽車表在汽車編號(hào)字段上建立索引create index driver_index on driver(driverID)。駕駛員表在駕駛員編號(hào)字段上建立索引create index line_index on line(lineID)。路線表在路線編號(hào)字段上建立索引create index take_time_index on line(take_time)。路線表在路線所需時(shí)間上建立索引，以備查詢各路線所需時(shí)間八．視圖，查詢各路線所花時(shí)間：create view take_time_listasselect line_ID,take_timefrom line。select * from take_time_list。結(jié)果如下:，查詢各路線所需票價(jià)create view ticket_priceasselect destination,start_address,ticket_pricefrom line；select * from ticket_price；結(jié)果如下:，查詢各路線行駛的所有駕駛員及車輛create view car_line_driverasselect ,start_address,driverID,from car,line,driverselect * from car_line_driver結(jié)果如下:九．查詢1．查詢有多少位駕駛員Select count (*) from driver執(zhí)行結(jié)果：select driverID, name,sex from driver執(zhí)行結(jié)果：select line_ID,destination from line where line_ID =39。20100539。執(zhí)行結(jié)果：，并按年齡降序排列。select name 駕駛員名, 2010brithday 年齡from driver inner join caron = order by 2 desc執(zhí)行結(jié)果：Select name 駕駛員名 ,standing 工齡 from driver where standing8執(zhí)行結(jié)果：select * from line。7. 查詢汽車表9 /
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1