MySQL数据库（三）数据导入导出 ，管理表记录，匹配条件，MySQL管理工具

一、数据导入导出
1.检索目录：数据导入导出时文件存放目录
mysql> show variables;   ==>>查看当前系统的所有变量值
mysql> show variables like "%file%";  ==>>查看当前系统的所有变量值包含file的
mysql> show variables like "secure_file_priv";   ==>>查看数据导入导出时文件存放目录
+------------------+-----------------------+
| Variable_name    | Value                 |
+------------------+-----------------------+
| secure_file_priv | /var/lib/mysql-files/ |
+------------------+-----------------------+
修改数据导入导出时文件存放目录
[root@mysql50 ~]# mkdir /myload
[root@mysql50 ~]# chown mysql /myload
[root@mysql50 ~]# vim /etc/my.cnf
secure_file_priv=/myload/    ==>>添加
[root@mysql50 ~]# systemctl restart mysqld
mysql> show variables like "secure_file_priv";
+------------------+----------+
| Variable_name    | Value    |
+------------------+----------+
| secure_file_priv | /myload/ |
+------------------+----------+

2.数据导入：把系统文件内容存储到数据库的表里
    命令格式：
    mysql> load data infile "文件的绝对路径" into table 库名.表名 
    -> fields terminated by "分隔符"
    -> lines terminated by "\n";
mysql> system cp /etc/passwd /myload/       ==>>添加system 执行系统命令
mysql> create database db3;
mysql> create table db3.user(
    -> name char(50),
    -> password char(1),
    -> uid int,
    -> gid int,
    -> comment varchar(150),