汽車站數(shù)據(jù)庫設(shè)計(jì)(存儲(chǔ)版)
【正文】 9120839。)。,39。insert into car_line (carID,lineID) values (39。20100339。邱冬39。路線表在路線所需時(shí)間上建立索引，以備查詢各路線所需時(shí)間八．視圖，查詢各路線所花時(shí)間：create view take_time_listasselect line_ID,take_timefrom line。7. 查詢汽車表9 / 9。駕駛員表在駕駛員編號(hào)字段上建立索引create index line_index on line(lineID)。)。9120239。20100439。insert into car_line (carID,lineID) values (39。,39。)。9120239。,39。南京39。)。,39。2個(gè)半小時(shí)39。,39。insert into line (line_ID,destination,take_time,start_address,ticket_price) values (39。蘇州39。,39。12339。20100139。,39。1239。09120839。,39。insert into driver (driverID,car_ID,name,brithday,sex,standing)values (39。朱翠翠39。,39。,39。197539。)。,39。139。1949100539。,39。939。09120339。,39。insert into driver (driverID,car_ID,name,brithday,sex,standing)values (39。吳士39。,39。毛驢39。,39。09120539。insert into car values(39。)。4539。字段含義字段名稱字段類型路線編號(hào)Line_IDChar(20) primary key目的地destinationchar(20) not null所需時(shí)間take_timechar(20)出發(fā)地start_addresschar(20) not null票價(jià)ticket_priceChar(20) not null創(chuàng)建路線表：CREATE TABLE line( line_ID char(20)primary key, destination char(20) not null, take_time char(20) , start_address char(20) not null， ticket_price char(20) not null)。：字段含義字段名稱字段類型汽車編號(hào)car_IDChar(20) primary key類型typechar(20)載客量capacityChar(20)創(chuàng)建汽車表表：CREATE TABLE car( car_ID char(20)primary key, type char(20)
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1