《MYSQL教程mysql學(xué)習(xí)筆記之基礎(chǔ)知識(shí)》要點(diǎn)：
本文介紹了MYSQL教程mysql學(xué)習(xí)筆記之基礎(chǔ)知識(shí)，希望對(duì)您有用。如果有疑問，可以聯(lián)系我們。

MYSQL必讀查看數(shù)據(jù)庫

MYSQL必讀show databases;


MYSQL必讀創(chuàng)立數(shù)據(jù)庫

MYSQL必讀create DATABASE 數(shù)據(jù)庫稱號(hào)

MYSQL必讀create DATABASE databasetest;

MYSQL必讀選擇數(shù)據(jù)庫

MYSQL必讀use 數(shù)據(jù)庫稱號(hào)

MYSQL必讀use databasetest;
------------
Database changed;切換勝利

MYSQL必讀查看當(dāng)前數(shù)據(jù)庫稱號(hào)

MYSQL必讀SELECT DATABASE();

MYSQL必讀刪除了數(shù)據(jù)庫

MYSQL必讀drop DATABASE 數(shù)據(jù)庫稱號(hào)

MYSQL必讀drop DATABASE databasetest;

MYSQL必讀數(shù)據(jù)庫狀況

MYSQL必讀
status;
--------------
mysql Ver 14.14 Distrib 5.7.17, for Win64 (x86_64)
Connection id:     5
Current database:
Current user:      root@localhost
SSL:          Not in use
Using delimiter:    ;
Server version:     5.7.17-log MySQL Co妹妹unity Server (GPL)
Protocol version:    10
Connection:       127.0.0.1 via TCP/IP
Server characterset:  utf8
Db   characterset:  utf8
Client characterset:  gbk
Conn. characterset:  gbk
TCP port:        3306
Uptime:         2 hours 25 min 34 sec
Threads: 2 Questions: 57 Slow queries: 0 Opens: 114 Flush tables: 1 Open tables: 107 Queries per second avg: 0.006
--------------

《MYSQL教程mysql學(xué)習(xí)筆記之基礎(chǔ)知識(shí)》是否對(duì)您有啟發(fā)，歡迎查看更多與《MYSQL教程mysql學(xué)習(xí)筆記之基礎(chǔ)知識(shí)》相關(guān)教程，學(xué)精學(xué)透。維易PHP學(xué)院為您提供精彩教程。

轉(zhuǎn)載請(qǐng)注明本頁網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/12666.html