mysql基本操作

https://www.runoob.com/mysql/mysql-connection.html

1.下载本地客户端

 sudo apt install mysql-client-core-8.0

2.远程登录mysql

mysql -h10.0.0.1 -uroot -p123
注：u与root可以不用加空格，其它也一样

3.选择数据库

use sangfor_platform

4.查看所有表

show tables

5.查看表的前10条数据

select * from sys_config limit 0,10;

6.插入一条记录

insert into sys_config (section,name,value,creator_at) values ("restfulUrl","trip_employee_url","http://200.200.4.131:8099/Common/EmployeeSelector?Action=GetEmployee&Key=",NOW());

7.centos 安装本地客户端

# 添加rpm源
[root@k8s-master ~]# rpm -ivh https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
[root@test1 ~]#
# 通过yum搜索
[root@test1 ~]# yum search mysql-community
[root@test1 ~]#
# 安装x64位的 mysql客户端
[root@test1 ~]# yum install mysql-community-client.x86_64

8查看所有库

show databases;