mysql -uroot -p进入数据库随便创建一个数据库create database hangzhou; use hangzhou;
创建个表create table t1 (id int(1),name varchar(20),age char(1),job varchar(20));
在root下建立个文件1.txt 内容如下，直接用tab隔开：
[root@192_168_2_193 ~]# vi 1.txt
1 lx 20 it
4.然后进入数据库执行load data local infile '/root/1.txt' into table t1;
5.查看结果：
mysql> show tables;
+--------------------+
| Tables_in_hangzhou |
+--------------------+
| t1 |
+--------------------+
1 row in set (0.00 sec)
mysql> load data local infile '/root/1.txt' into table t1;
Query OK, 1 row affected, 1 warning (0.00 sec)
Records: 1 Deleted: 0 Skipped: 0 Warnings: 1
mysql> select * from t1;
+------+------+------+------+
| id | name | age | job |
+------+------+------+------+
| 1 | lx | 2 | it |
+------+------+------+------+
1 row in set (0.00 sec)
