最新大學(xué)計(jì)算機(jī)基礎(chǔ)excel實(shí)驗(yàn)報(bào)告(4篇)(編輯修改稿)
2025-08-13 13:24 本頁面
【文章內(nèi)容簡介】 char(2), grade int)。query ok, 0 rows affected( sec)mysql desc score。+++++++ | field | type | null | key | default | extra | +++++++ | sno | char(4)| no | pri | null | | | o | char(2)| yes | | null | | | grade | int(11)| yes | | null | | +++++++ 3 rows in set( sec)，查看操作結(jié)果。mysql insert into stu values(39。139。,39。jobs39。,39。man39。,22,39。1991041339。,39。g2c239。)。query ok, 1 row affected, 2 warnings( sec)mysql insert into stu values(39。239。,39。susan39。,39。feman39。,23,39。1988020339。,39。g2c239。)。query ok, 1 row affected, 2 warnings( sec)mysql insert into stu values(39。339。,39。bob39。,39。man39。,23,39。1979010339。,39。g2c239。)。query ok, 1 row affected, 2 warnings( sec)mysql insert into score values(39。139。,39。139。,23)。query ok, 1 row affected( sec)mysql insert into score values(39。139。,39。239。,43)。query ok, 1 row affected( sec)mysql insert into score values(39。139。,39。339。,63)。query ok, 1 row affected( sec)mysql insert into score values(39。139。,39。439。,93)。query ok, 1 row affected( sec)mysql insert into score values(39。239。,39。139。,56)。query ok, 1 row affected( sec)mysql insert into score values(39。339。,39。139。,66)。query ok, 1 row affected( sec)mysql insert into course values(39。139。,39。g2c239。,22)。query ok, 1 row affected, 1 warning( sec)mysql select birthday from stu where sno=39。239。 or sname=39。jobs39。++ | birthday | ++ | 19910413 00:00:00 | | 19880203 00:00:00 | ++ 2 rows in set( sec)：++ | sname | ++ | jobs | | susan | | bob | ++ 3 rows in set( sec)。mysql select , from score r inner join stu s on = inner join course c on = 。++++ | grade | sname | ame | ++++ | 23 | jobs | g2c2 | | 56 | susan | g2c2 | | 66 | bob | g2c2 | ++++ 3 rows in set( sec)mysql select , from score r inner join stu s on = inner join course c on = where 60。++++ | grade | sname | ame | ++++ | 23 | jobs | g2c2 | | 56 | susan | g2c2 | ++++ 2 rows in set( sec)。mysql select , sum()as zcj,avg()as pjcj from score s inner join stu t on = where sname = 39。jobs39。++++ | sname | zcj | pjcj | ++++ | jobs | 222 | | ++++ 1 row in set( sec)。mysql select from stu t inner join score s on = having count( 85)= 4。empty set( sec)“軟件技術(shù)”mysql update course set ame = 39。軟件技術(shù)39。 where o = 1。query ok, 1 row affected, 1 warning( sec)rows matched: 1 changed: 1 warnings: 1++++ | o | ame | chour | ++++ | 1 | 軟件技術(shù) | 22 | ++++ 1 row in set( sec)mysql update stu set sname = 39。ruby39。,sex = 39。f39。,age = 31 where sno = 3。query ok, 1 row affected( sec)rows matched: 1 changed: 1 warnings: 0mysql select * from stu where sname =39。ruby39。+++++++ | sno | sname | sex | age | birthday | class | +++++++ | 3 | ruby | f | 31 | 19780203 00:00:00 | g2c2 | +++++++ 1 row in set( sec) 5559分的男生的成績修改為60分。mysql update score s inner join stu t on = set = 60 where = 39。man39。 and between 55 and 59。，80年以前出生的學(xué)生的所有信息成績。mysql delete from stu where birthday 39。19900101 00:00:0039。 or birthday 39。19800101 00:00:0
外語相關(guān)推薦
鄂ICP備17016276號-1