涓�銆?/p>
1
锛庣櫥褰曟暟鎹簱绯荤粺
mysql
鈥?/p>
h localhost
鈥?/p>
u root -p
2
锛庢煡鐪嬪凡瀛樺湪鐨勬暟鎹簱
SHOW DATABASES;
3
锛庢煡鐪嬮粯璁ゅ瓨鍌ㄥ紩鎿?/p>
SHOW
V
ARIABLES
LIKE
'storage_engine';
4
锛庡垱寤烘暟鎹簱
CREATE DATABASE school;
5
锛庡垹闄ゆ暟鎹簱
DROP DATABASE school;
浜屻�?/p>
锛?/p>
1
锛夌櫥褰曟暟鎹簱
mysql -h localhost -u root -p
锛?/p>
2
锛夋煡鐪嬫暟鎹簱绯荤粺涓凡瀛樺湪鐨勬暟鎹簱锛屼唬鐮佸涓嬶細
SHOW
DATABASES;
锛?/p>
3
锛夋煡鐪嬭鏁版嵁搴撶郴缁熸敮鎸佺殑瀛樺偍寮曟搸鐨勭被鍨嬶紝浠ｇ爜濡備笅锛?/p>
SHOW
ENGINES;
锛?/p>
4
锛夊垱寤?/p>
student
鏁版嵁搴撳拰
teacher
鏁版嵁搴撱�?/p>
CREATE
DA
TABASE
student;
CREATE
DA
TABASE
teacher;
锛?/p>
5
锛夊啀娆℃煡鐪嬫暟鎹簱绯荤粺涓凡缁忓瓨鍦ㄧ殑鏁版嵁搴擄紝纭繚
student
鍜?/p>
teacher
鏁版嵁搴撳凡缁忓瓨鍦紝
浠ｇ爜濡備笅锛?/p>
SHOW
DATABASES;
锛?/p>
6
锛夊垹闄?/p>
teacher
鏁版嵁搴擄紝浠ｇ爜濡備笅锛?/p>
DROP
DATABASE
teacher ;
锛?/p>
7
锛夊啀娆℃煡鐪嬫暟鎹簱绯荤粺涓凡缁忓瓨鍦ㄧ殑鏁版嵁搴擄紝纭繚
teacher
鏁版嵁搴撳凡缁忓垹闄ゃ�?/p>
SHOW
DATABASES;
涓夈�?/p>