免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版

創(chuàng)建數(shù)據(jù)庫：Navicat軟件中，mysql80右擊選中命令列介面，輸入CREATE ?DATABASE ?itcast; 然后回車輸入SHOW ?DATABASES; ?然后回車，輸入SHOW CREATE DATABASE itcast;

?

刪除數(shù)據(jù)庫：輸入DROP DATABASE itcast;?（刪除itcast），回車，然后可以查看一下是否刪除，輸入SHOW DATABASES;

?

以下是成功的命令

?

mysql> DROP DATABASE itcast;

Query OK, 0 rows affected

?

mysql> SHOW DATABASES;

--------------------

| Database ??????????|

--------------------

| information_schema |

| mysql ?????????????|

| performance_schema |

| test ??????????????|

--------------------

4 rows in set

?

?

?

mysql> CREATE TABLE tb_grade

????-> (

????-> id ??INT(11),

????-> name VARCHAR(20),

????-> grade FLOAT

????-> );

Query OK, 0 rows affected

?

mysql> SHOW TABLES;

------------------

| Tables_in_itcast |

------------------

| tb_grade ????????|

------------------

1 row in set

?

?

?

?

mysql> CREATE TABLE tb_grade

????-> (

????-> id ??INT(11),

????-> name VARCHAR(20),

????-> grade FLOAT

????-> );

Query OK, 0 rows affected

?

mysql> SHOW TABLES;

------------------

| Tables_in_itcast |

------------------

| tb_grade ????????|

------------------

1 row in set

?

?