【正文】
not null)。字段含義字段名稱字段類型汽車編號carIDChar(20)路線編號lineIDchar(20)創(chuàng)建汽車路線表:CREATE TABLE car_line( carID char(20), lineID char(20), primary key(carID,lineID))。.字段含義字段名稱字段類型汽車編號usernameChar(20)路線編號password char(20)創(chuàng)建用戶表表:CREATE TABLE user_ID( username varchar(20), password varchar(20), primary key(username,password))。insert into car values(39。09120139。,39。飛鶴39。,39。4539。)。insert into car values(39。09120239。,39??炻?9。,39。4039。)。insert into car values(39。09120339。,39。鴕鳥39。,39。4239。)。insert into car values(39。09120439。,39。風火輪39。,39。4539。)。insert into car values(39。09120539。,39。筋斗云39。,39。3839。)。insert into car values(39。09120639。,39。白龍馬39。,39。4239。)。insert into car values(39。09120739。,39。毛驢39。,39。3639。)。insert into car values(39。09120839。,39。青牛39。,39。5039。)。insert into driver (driverID,car_ID,name,brithday,sex,standing)values (39。1949100139。,39。09120139。,39。吳士39。,39。198139。,39。139。,39。639。)。insert into driver (driverID,car_ID,name,brithday,sex,standing)values (39。1949100239。,39。09120439。,39。孫悟39。,39。197439。,39。139。,39。1539。)。insert into driver (driverID,car_ID,name,brithday,sex,standing)values (39。1949100339。,39。09120339。,39。李嬌39。,39。197939。,39。039。,39。939。)。insert into driver (driverID,car_ID,name,brithday,sex,standing)values (39