大學(xué)計算機基礎(chǔ)實驗報告-資料下載頁
2024-10-29 02:43本頁面
【正文】 ted, 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 | Cname | ++++ | 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 | Cname | ++++ | 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 Cname = 39。軟件技術(shù)39。 where Cno = 1。Query OK, 1 row affected, 1 warning( sec)Rows matched: 1 Changed: 1 Warnings: 1++++ | Cno | Cname | 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:0039。mysql DELETE FROM Stu WHERE Class = 39。G2C239。mysql drop table Stu。Query OK, 0 rows affected( sec)mysql drop table Course。Query OK, 0 rows affected( sec)mysql drop table Score。Query OK, 0 rows affected( sec)mysql drop database MyDB。Query OK, 0 rows affected( sec)mysql show databases。++ | Database | ++ | information_schema | | mysql | | newmato_development | | newmato_test | ++ 4 rows in set( sec)mysql quit Bye
醫(yī)療健康相關(guān)推薦
鄂ICP備17016276號-1