實(shí)訓(xùn)案例名稱：數(shù)據(jù)庫(kù)操作一、任務(wù)介紹MySQL允許創(chuàng)建多個(gè)數(shù)據(jù)庫(kù)，每個(gè)數(shù)據(jù)庫(kù)承載不同的內(nèi)容，使用命令操作可以查看數(shù)據(jù)庫(kù)、創(chuàng)建數(shù)據(jù)庫(kù)、使用數(shù)據(jù)庫(kù)以及刪除數(shù)據(jù)庫(kù)。二、實(shí)現(xiàn)步驟1.查看數(shù)據(jù)庫(kù)#使用用戶名root和相應(yīng)密碼，連接本地MySQLC:\Users\Administrator>mysql-uroot-p123456mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.#查看數(shù)據(jù)庫(kù)mysql>SHOWDATABASES;+------------------------------+|Database

|+------------------------------+|information_schema

||mysql

||performance_schema

||sys

||test

|+------------------------------+5rowsinset(0.00sec)2.創(chuàng)建數(shù)據(jù)庫(kù)#使用用戶名root和相應(yīng)密碼，連接本地MySQLC:\Users\Administrator>mysql-uroot-p123456mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.#查看數(shù)據(jù)庫(kù)mysql>SHOWDATABASES;+------------------------------+|Database

|+------------------------------+|information_schema

||mysql

||performance_schema

||sys

||test

|+------------------------------+5rowsinset(0.00sec)3.使用數(shù)據(jù)庫(kù)#使用用戶名root和相應(yīng)密碼，連接本地MySQLC:\Users\Administrator>mysql-uroot-p123456mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.#使用shop數(shù)據(jù)庫(kù)mysql>USEshop;Databasechangedmysql>4.刪除數(shù)據(jù)庫(kù)#使用用戶名root和相應(yīng)密碼，連接本地MySQLC:\Users\Administrator>mysql-uroot-p123456mysql:[Warning]Usingapasswordonthecommandlineinterfacecanbeinsecure.#查看數(shù)據(jù)庫(kù)mysql>SHOWDATABASES;+-----------------------------+|Database

|+-----------------------------+|information_schema

||mysql

||performance_schema

||shop

||sys

||test

|+-----------------------------+6rowsinset(0.00sec)#刪除shop數(shù)據(jù)庫(kù)mysql>DROPDATABASEshop;QueryOK,0rowsaffected(0.46sec)#查看數(shù)據(jù)庫(kù)mysql>SHOWDATABASES;+-----------------------------+|Database

|+-----------------------------+|information_schema

||mysql

||performance_schema

||