大學計算機基礎(chǔ)實驗報告(參考版)
2024-10-29 02:43本頁面
【正文】 Query OK, 0 rows affected( sec)mysql show databases。Query OK, 0 rows affected( sec)mysql drop table Score。mysql drop table Stu。mysql DELETE FROM Stu WHERE Class = 39。 OR Birthday 39。mysql DELETE FROM Stu WHERE Birthday 39。 AND BETWEEN 55 AND 59。mysql update Score s inner join Stu t on = set = 60 where = 39。Ruby39。,Age = 31 where Sno = 3。,sex = 39。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。軟件技術(shù)39。mysql select from Stu t inner join Score s on = having count( 85)= 4。Jobs39。++++ | Grade | Sname | Cname | ++++ | 23 | Jobs | G2C2 | | 56 | Susan | G2C2 | ++++ 2 rows in set( sec)。mysql select , from Score r inner join Stu s on = inner join Course c on = 。Jobs39。239。,22)。,39。Query OK, 1 row affected( sec)mysql insert into Course values(39。139。339。,56)。,39。Query OK, 1 row affected( sec)mysql insert into Score values(39。439。139。,63)。,39。Query OK, 1 row affected( sec)mysql insert into Score values(39。239。139。,23)。,39。Query OK, 1 row affected, 2 warnings( sec)mysql insert into Score values(39。G2C239。1979010339。man39。Bob39。339。)。,39。,23,39。,39。,39。Query OK, 1 row affected, 2 warnings( sec)mysql insert into Stu values(39。G2C239。1991041339。man39。Jobs39。139。+++++++ | Field | Type | Null | Key | Default | Extra | +++++++ | Sno | char(4)| NO | PRI | NULL | | | Cno | char(2)| YES | | NULL | | | Grade | int(11)| YES | | NULL | | +++++++ 3 rows in set( sec)，查看操作結(jié)果。+++++++ | Field | Type | Null | Key | Default | Extra | +++++++ | Cno | char(2)| NO | PRI | NULL | | | Cname | char(10)| YES | | NULL | | | Chour | int(4)| YES | | NULL | | +++++++ 3 rows in set( sec) Scoremysql create table Score( Sno char(4)primary key, Cno char(2), Grade int)。+++++++ | Field | Type | Null | Key | Default | Extra | +++++++ | Sno | char(4)| NO | PRI | NULL | | | Sname | char(10)| YES | | NULL | | | Sex | char(2)| YES | | NULL | | | Age | int(4)| YES | | NULL | | | Birthday | datetime | YES | | NULL | | | Class | char(10)| YES | | NULL | | +++++++ 6 rows in set( sec) Coursemysql create table Course( Cno char(2)
醫(yī)療健康相關(guān)推薦
鄂ICP備17016276號-1