[备忘录] Centos7.3 MySQL数据库操作

登录MySQL：

语法：
mysql -u用户名 -p，加上回车，然后输入密码
举例：

mysql -uroot -p

然后出现如下回复：

[root@iZbp189c2y7tncvde8xwtpZ admin]# mysql -uroot -p
Enter password:

正确输入自己设置的密码后，出现如下回复：

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 59
Server version: 5.7.32 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, 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> 

在MySQL数据库中创建表

创建 “test” 数据库:

CREATE DATABASE test;

创建 t_mqtt_msg 表：

USE test;
CREATE TABLE `t_mqtt_msg` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`msgid` varchar(64) DEFAULT NULL,
`topic` varchar(255) NOT NULL,
`qos` tinyint(1) NOT NULL DEFAULT '0',
`payload` blob,
`arrived` datetime NOT NULL,
PRIMARY KEY (`id`),
INDEX topic_index(`id`, `topic`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8MB4;

展示表结构：

describe t_mqtt_msg;

出现回复：

+---------+------------------+------+-----+---------+----------------+
| Field   | Type             | Null | Key | Default | Extra          |
+---------+------------------+------+-----+---------+----------------+
| id      | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| msgid   | varchar(64)      | YES  |     | NULL    |                |
| topic   | varchar(255)     | NO   |     | NULL    |                |
| qos     | tinyint(1)       | NO   |     | 0       |                |
| payload | blob             | YES  |     | NULL    |                |
| arrived | datetime         | NO   |     | NULL    |                |
+---------+------------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)