數(shù)據(jù)庫(kù)公交車(chē)管理系統(tǒng)課程設(shè)計(jì)(參考版)
2025-04-10 23:10本頁(yè)面
【正文】 嵌套查詢(xún)：select Nidfrom bus where id in (select id from siji where age31)。多表查詢(xún)：select cid,xingbie from bus,siji where = and age=39。139。139。)。,39。雙層公車(chē),39。339。339。339。)。,39。單層公車(chē),39。239。,39。insertinto bus(cid,id,nid,leixing,nian,time)values(39。2016 06 0139。839。,39。,39。,39。建立siji表：CREATE table siji(id char(10)not null primary key, mingzi char(10)not null, xingbie char(2)not null, age int not null, age2 char(5)not null, constraint C1 check(age=25 and age2=5), tel char(12) not null)增加數(shù)據(jù)到bus表中 insertint
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1