常用命令
提示
SQL语句不区分大小写
# 查看数据库版本号
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.40 |
+-----------+
1 row in set (0.00 sec)
1
2
3
4
5
6
7
2
3
4
5
6
7
# 创建数据库
mysql> create database aarondb;
Query OK, 1 row affected (0.00 sec)
1
2
2
# 显示数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| aarondb |
| mysql |
| performance_schema |
| test |
+--------------------+
5 rows in set (0.00 sec)
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
# 使用数据库
mysql> use aarondb;
Database changed
1
2
2
# 查看当前使用的数据库
mysql> select database();
+------------+
| database() |
+------------+
| aarondb |
+------------+
1 row in set (0.00 sec)
1
2
3
4
5
6
7
2
3
4
5
6
7
# 查看数据库中的表
mysql> show tables;
+-------------------+
| Tables_in_aarondb |
+-------------------+
| department |
| employ |
| student |
| user |
+-------------------+
4 rows in set (0.00 sec)
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
# 导入 SQL 文件
mysql> source F:\tools\Mysql\SQL\UserTable.sql
Query OK, 0 rows affected (0.01 sec)
Query OK, 3 rows affected (0.01 sec)
Records: 3 Duplicates: 0 Warnings: 0
+----+--------+----------+
| id | NAME | PASSWORD |
+----+--------+----------+
| 1 | 寮犱笁 | 123456 |
| 2 | 鏉庡洓 | 123456 |
| 3 | 鐜嬩簲 | 123456 |
+----+--------+----------+
3 rows in set (0.00 sec)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
2
3
4
5
6
7
8
9
10
11
12
13
14
# 移除数据库
mysql> drop database aarondb;
Query OK, 12 rows affected (0.02 sec)
1
2
2
# 查看表中的数据
mysql> show tables;
+-------------------+
| Tables_in_aarondb |
+-------------------+
| department |
| employ |
| student |
| user |
+-------------------+
4 rows in set (0.00 sec)
mysql> select * from student;
+------+------+------+---------+--------+---------------------+------+---------+---------+-----------+
| id | name | age | chinese | gender | birthday | math | english | address | grade |
+------+------+------+---------+--------+---------------------+------+---------+---------+-----------+
| 1 | 王维 | 33 | 100 | 男 | 1923-01-01 00:00:00 | 98 | 87 | 天津 | 三年级1班 |
| 2 | 李白 | 43 | 99 | 女 | 1913-01-01 00:00:00 | 88 | 89 | 上海 | 三年级2班 |
| 3 | 杜甫 | 34 | 98 | 男 | 1929-01-01 00:00:00 | 96 | 79 | 天津 | 三年级3班 |
| 4 | 郭靖 | 36 | 97 | 男 | 1923-01-01 00:00:00 | 96 | 99 | 北京 | 三年级1班 |
| 5 | 王良 | 66 | 97 | 女 | 1943-01-01 00:00:00 | 90 | 88 | 天津 | 三年级3班 |
| 6 | 刘邦 | 46 | 95 | 男 | 1953-01-01 00:00:00 | 93 | 88 | NULL | 三年级2班 |
+------+------+------+---------+--------+---------------------+------+---------+---------+-----------+
6 rows in set (0.00 sec)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
# 查看表结构
mysql> desc student;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| name | varchar(60) | YES | | NULL | |
| age | int(11) | YES | | NULL | |
| chinese | double | YES | | NULL | |
| gender | char(3) | YES | | NULL | |
| birthday | datetime | YES | | NULL | |
| math | int(11) | YES | | NULL | |
| english | int(11) | YES | | NULL | |
| address | varchar(20) | YES | | NULL | |
| grade | varchar(20) | YES | | NULL | |
+----------+-------------+------+-----+---------+-------+
10 rows in set (0.00 sec)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
# 查看默认事务隔离级别
mysql> select @@tx_isolation;
+-----------------+
| @@tx_isolation |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set (0.00 sec)
1
2
3
4
5
6
7
2
3
4
5
6
7
# 设置全局隔离级别
mysql> set global transaction isolation level read uncommitted;
Query OK, 0 rows affected (0.00 sec)
1
2
2
编辑 (opens new window)
上次更新: 2025/02/10, 20:20:37