mysql庫(kù)基礎(chǔ)命令匯總
1 登錄MySQL數(shù)據(jù)庫(kù)
綏寧網(wǎng)站建設(shè)公司成都創(chuàng)新互聯(lián)公司,綏寧網(wǎng)站設(shè)計(jì)制作，有大型網(wǎng)站制作公司豐富經(jīng)驗(yàn)。已為綏寧上千家提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\外貿(mào)網(wǎng)站制作要多少錢，請(qǐng)找那個(gè)售后服務(wù)好的綏寧做網(wǎng)站的公司定做！
[root@db02--52 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.6.34-log Source distribution
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
2 查看當(dāng)前登錄的用戶：
mysql> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.20 sec)
mysql>
3 創(chuàng)建數(shù)據(jù)庫(kù)haha，并查看已建庫(kù)完整語(yǔ)句
mysql> create database haha; 創(chuàng)建數(shù)據(jù)庫(kù)haha
Query OK, 1 row affected (0.00 sec)
mysql> show create database haha;查看剛健的數(shù)據(jù)庫(kù)
+----------+---------------------------------------------------------------+
| Database | Create Database |
+----------+---------------------------------------------------------------+
| haha | CREATE DATABASE `haha` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+---------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show databases; 查看所有的數(shù)據(jù)庫(kù)
+--------------------+
| Database |
+--------------------+
| information_schema |
| haha |
| mysql |
| oldboy |
| oldgril |
| performance_schema |
| xinpan |
| xu |
+--------------------+
8 rows in set (0.00 sec)
mysql>
4 創(chuàng)建用戶hehe 使之可以管理數(shù)據(jù)庫(kù)haha
mysql> create user hehe@'localhost' identified by 'oldboy123'
-> ;創(chuàng)建本地用戶hehe 授權(quán)數(shù)據(jù)庫(kù)密碼
Query OK, 0 rows affected (0.06 sec)
mysql> grant all on haha.* to hehe@'localhost';haha為數(shù)據(jù)庫(kù)，hehe為用戶
Query OK, 0 rows affected (0.00 sec)
5 查看創(chuàng)建的用戶hehe擁有哪些權(quán)限
mysql> show grants for hehe@'localhost';查看創(chuàng)建的用戶hehe擁有哪些權(quán)限
+-------------------------------------------------------------------------------------------------------------+
| Grants for hehe@localhost |
+-------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'hehe'@'localhost' IDENTIFIED BY PASSWORD '*FE28814B4A8B3309DAC6ED7D3237ADED6DA1E515' |
| GRANT ALL PRIVILEGES ON `oldboy`.* TO 'hehe'@'localhost' |
| GRANT ALL PRIVILEGES ON `hehe`.* TO 'hehe'@'localhost' |
| GRANT ALL PRIVILEGES ON `haha`.* TO 'hehe'@'localhost' |
+-------------------------------------------------------------------------------------------------------------+
4 rows in set (0.03 sec)
6 查看當(dāng)前數(shù)據(jù)庫(kù)里有哪些用戶。
mysql>
mysql> select user,host from mysql.user;
+-----------+------------+
| user | host |
+-----------+------------+
| keke | % |
| oldboy | % |
| xinjia | % |
| mha | 10.0.0.% |
| rep | 10.0.0.% |
| root | 127.0.0.1 |
| bbs | 172.16.1.% |
| wordpress | 172.16.1.% |
| root | db02--52 |
| haha | localhost |
| hehe | localhost |
| oldboy | localhost |
| root | localhost |
| system | localhost |
+-----------+------------+
14 rows in set (0.00 sec)
mysql>
6 進(jìn)入oldboy數(shù)據(jù)庫(kù)
mysql> use oldboy
Database changed
mysql>
7 查看當(dāng)前所在的數(shù)據(jù)庫(kù)
mysql> select database();
+------------+
| database() |
+------------+
| oldboy |
+------------+
1 row in set (0.00 sec)
mysql>
8 創(chuàng)建一張表xiaoke 字段id和name varchar（16）
mysql> create table xiaoke ( id int(4) not null, name varchar (16) not null);
Query OK, 0 rows affected (0.63 sec)
mysql>
9查看建表結(jié)構(gòu)以及表結(jié)構(gòu)的sql語(yǔ)句
mysql> desc xiaoke 查看表的結(jié)構(gòu)
-> ;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(4) | NO | | NULL | |
| name | varchar(16) | NO | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.03 sec)
查看表結(jié)構(gòu)的sql語(yǔ)句
mysql> show full columns from xiaoke; 查看表結(jié)構(gòu)的sql語(yǔ)句
+-------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+-------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| id | int(4) | NULL | NO | | NULL | | select,insert,update,references | |
| name | varchar(16) | utf8_general_ci | NO | | NULL | | select,insert,update,references | |
+-------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
2 rows in set (0.00 sec)
mysql>
10 插入一條數(shù)據(jù)“1，aini”
mysql> insert into test(id,name) values(1,'aini');
Query OK, 1 row affected (0.02 sec)
mysql> select * from test;
+----+------+--------+
| id | age | name |
+----+------+--------+
| 1 | NULL | oldboy |
| 1 | NULL | oldboy |
| 1 | NULL | aini |
+----+------+--------+
3 rows in set (0.02 sec)
mysql>
11 再批量插入2行數(shù)據(jù)“2，xiaoxu”“3，xiaoxin”
mysql> insert into test(id,name) values(2,'xaioke'),(3,'xiaoxin');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from test;
+----+------+---------+
| id | age | name |
+----+------+---------+
| 1 | NULL | oldboy |
| 1 | NULL | oldboy |
| 1 | NULL | aini |
| 2 | NULL | xaioke |
| 3 | NULL | xiaoxin |
+----+------+---------+
5 rows in set (0.00 sec)
12 查詢名字為oldboy的記錄
mysql> select * from test where name='oldboy';
+----+------+--------+
| id | age | name |
+----+------+--------+
| 1 | NULL | oldboy |
| 1 | NULL | oldboy |
+----+------+--------+
2 rows in set (0.00 sec)
mysql>
13 把數(shù)據(jù)庫(kù)id等于1的名字oldboy更改為oldgril
mysql> select * from test where name='oldboy';
+----+------+--------+
| id | age | name |
+----+------+--------+
| 1 | NULL | oldboy |
| 1 | NULL | oldboy |
+----+------+--------+
2 rows in set (0.00 sec)
mysql> updata test set name='oldgirl' where id='1';
mysql> select * from test;
+----+------+---------+
| id | age | name |
+----+------+---------+
| 1 | NULL | oldgirl |
| 1 | NULL | oldgirl |
| 1 | NULL | oldgirl |
| 2 | NULL | xaioke |
| 3 | NULL | xiaoxin |
+----+------+---------+
5 rows in set (0.00 sec)
mysql>
未完待續(xù)。。。。。
網(wǎng)頁(yè)標(biāo)題：mysql庫(kù)基礎(chǔ)命令匯總
網(wǎng)站路徑：http://bm7419.com/article20/igdpco.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站維護(hù)、域名注冊(cè)、靜態(tài)網(wǎng)站、網(wǎng)站建設(shè)、用戶體驗(yàn)、定制網(wǎng)站
聲明：本網(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í)需注明來(lái)源： 創(chuàng)新互聯(lián)
- 響應(yīng)式網(wǎng)站與獨(dú)立手機(jī)站，企業(yè)做網(wǎng)站該如何選擇？ 2022-08-04
- 響應(yīng)式網(wǎng)站如何做更吸引用戶眼球 2021-09-24
- 創(chuàng)新互聯(lián)H5響應(yīng)式網(wǎng)站，一個(gè)網(wǎng)站能夠兼容多個(gè)終端的網(wǎng)站 2021-04-14
- 響應(yīng)式網(wǎng)站布局設(shè)計(jì)新手必備三大技巧 2022-05-17
- 響應(yīng)式網(wǎng)站建設(shè)需要注意的一些細(xì)節(jié) 2022-05-11
- 建設(shè)響應(yīng)式網(wǎng)站一般有哪些費(fèi)用？ 2023-01-09
- 搭建響應(yīng)式網(wǎng)站的9個(gè)理由 2022-12-09
- 什么是響應(yīng)式網(wǎng)站設(shè)計(jì)？有什么好處？ 2016-08-29
- 響應(yīng)式網(wǎng)站是什么意思 2021-09-19
- 所有的行業(yè)都適合進(jìn)行響應(yīng)式網(wǎng)站制作嗎？ 2016-10-18
- 關(guān)于響應(yīng)式網(wǎng)站設(shè)計(jì) (Responsive Web Design) 為什么要做響應(yīng)式網(wǎng)站? 2019-11-25
- 什么叫響應(yīng)式網(wǎng)站？響應(yīng)式網(wǎng)站的好處。 2016-11-25