數(shù)據(jù)庫(kù)公交車(chē)管理系統(tǒng)課程設(shè)計(jì)-wenkub
2023-04-22 23:10:23 本頁(yè)面
【正文】 車(chē),39。)。139。嵌套查詢(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。,39。339。339。,39。239。insertinto bus(cid,id,nid,leixing,nian,time)values(39。839。,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表中 insertinto bus(cid,id,nid,leixing,nian,time)value
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1