1.在Linux下安裝MySQL
創(chuàng)新互聯(lián)建站歡迎咨詢:13518219792,為您提供成都網(wǎng)站建設(shè)網(wǎng)頁(yè)設(shè)計(jì)及定制高端網(wǎng)站建設(shè)服務(wù),創(chuàng)新互聯(lián)建站網(wǎng)頁(yè)制作領(lǐng)域十余年,包括成都食品包裝袋等多個(gè)領(lǐng)域擁有豐富的網(wǎng)站制作經(jīng)驗(yàn),選擇創(chuàng)新互聯(lián)建站,為企業(yè)保駕護(hù)航。
# yum -y install mysql mysql-server mysql-devel
修改字符集:/etc/my.conf配置文件
vi /etc/my.conf [mysqld] default-character-set=utf8 character_set_server=utf8 [client] default-character-set=utf8
2.啟動(dòng)和停止MySQL服務(wù)
# service mysqld start
3.登錄MySQL:
# mysql -uroot
4.修改MySQL提示符:
修改MySQL提示符
# mysql -uroot -proot --prompt ‘<提示符>’ //在windows中不用‘’
或 連接進(jìn)MySQL后修改:
mysql> prompt <提示符>
常用的MySQL提示符:
\D | 完整的日期 | |
\d | 當(dāng)前數(shù)據(jù)庫(kù) | |
\h | 服務(wù)器名稱 | |
\u | 當(dāng)前用戶 | |
例:
# mysql -uroot --prompt '\u@\h \d' root@localhost (none) //或 mysql> prompt \u@\h \d> PROMPT set to '\u@\h \d>' root@localhost (none)>
5.MySQL常用命令
顯示當(dāng)前服務(wù)器版本號(hào):
mysql> SELECT VERSION(); +-----------+ | VERSION() | +-----------+ | 5.1.71 | +-----------+ 1 row in set (0.00 sec)
顯示當(dāng)前用戶:
mysql> SELECT USER(); +----------------+ | USER() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.00 sec)
顯示當(dāng)前日期時(shí)間:
mysql> SELECT NOW(); +---------------------+ | NOW() | +---------------------+ | 2016-11-20 21:32:55 | +---------------------+ 1 row in set (0.00 sec)
7.MySQL語(yǔ)句規(guī)范:
***關(guān)鍵字與函數(shù)名稱全部大寫
***數(shù)據(jù)庫(kù)名稱,表名稱,字段名稱全部小寫
***SQL語(yǔ)句必須以分號(hào)結(jié)尾
8.數(shù)據(jù)庫(kù)基本操作:
數(shù)據(jù)庫(kù)創(chuàng)建:
mysql> CREATE DATABASE test1;
加上 IF NOT EXISTS,若已存在該數(shù)據(jù)庫(kù),會(huì)提示警告信息:
mysql> CREATE DATABASE IF NOT EXISTS test1; Query OK, 1 row affected, 1 warning (0.00 sec)
查看警告信息:.
mysql> SHOW WARNINGS; +-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code | Message | +-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ | Error | 1064 | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WARNING' at line 1 | +-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
查看數(shù)據(jù)庫(kù)列表:
mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | | test1 | +--------------------+ 4 rows in set (0.00 sec)
顯示數(shù)據(jù)庫(kù)創(chuàng)建的時(shí)候使用的指令:
mysql> SHOW CREATE DATABASE test1; +----------+----------------------------------------------------------------+ | Database | Create Database | +----------+----------------------------------------------------------------+ | test1 | CREATE DATABASE `test1` /*!40100 DEFAULT CHARACTER SET utf8 */ | +----------+----------------------------------------------------------------+ 1 row in set (0.00 sec)
創(chuàng)建與配置文件不一樣的數(shù)據(jù)庫(kù)編碼方式(例GBK):
mysql> CREATE DATABASE IF NOT EXISTS test2 CHARACTER SET gbk; Query OK, 1 row affected (0.00 sec) mysql> SHOW CREATE DATABASE test2; +----------+---------------------------------------------------------------+ | Database | Create Database | +----------+---------------------------------------------------------------+ | test2 | CREATE DATABASE `test2` /*!40100 DEFAULT CHARACTER SET gbk */ | +----------+---------------------------------------------------------------+ 1 row in set (0.00 sec)
修改數(shù)據(jù)庫(kù)編碼方式修改:
mysql> ALTER DATABASE test2 CHARACTER SET utf8;
或
mysql> ALTER DATABASE test2 CHARACTER SET = utf8;
刪除數(shù)據(jù)庫(kù):
mysql> DROP DATABASE test1;
網(wǎng)頁(yè)名稱:MySQL學(xué)習(xí)筆記初涉MySQL
分享網(wǎng)址:http://bm7419.com/article10/gihcdo.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供電子商務(wù)、品牌網(wǎng)站建設(shè)、標(biāo)簽優(yōu)化、品牌網(wǎng)站制作、自適應(yīng)網(wǎng)站、網(wǎng)站維護(hù)
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)