【10-11】MySQL常用命令
2022-02-10 20:11:00 # MySQL

查看 mysql 版本

dos下 

1
2
mysql --version
mysql -V

创建数据库

MySQL下 

1
create database xxx;

使用数据库

1
use xxx;

查询当前使用数据库

1
2
3
4
5
6
mysql> select database();
+------------+
| database() |
+------------+
| sunlie     |
+------------+

查询当前数据库版本

1
2
3
4
5
6
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.28    |
+-----------+

终止一条语句

使用”\c”终止 

1
2
3
4
5
6
mysql> select
    ->
    -> *
    ->
    -> \c
mysql>

退出MySQL

1
2
3
4
\q
(ctrl+c)
QUIT
EXIT

查看创建表的sql语句

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
mysql> show create table emp
    -> ;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                                                                                                             |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| emp   | CREATE TABLE `emp` (
  `EMPNO` int NOT NULL,
  `ENAME` varchar(10) DEFAULT NULL,
  `JOB` varchar(9) DEFAULT NULL,
  `MGR` int DEFAULT NULL,
  `HIREDATE` date DEFAULT NULL,
  `SAL` double(7,2) DEFAULT NULL,
  `COMM` double(7,2) DEFAULT NULL,
  `DEPTNO` int DEFAULT NULL,
  PRIMARY KEY (`EMPNO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Prev
2022-02-10 20:11:00 # MySQL
Next