-
准备csv文件
-
创建表
-
使用ssh工具登录虚拟机服务器,将user.csv上传到服务器
[root@master data]# pwd
/home/data
[root@master data]# ls
user.csv
# 开始导入
[root@master data]# mysqlimport -h127.0.0.1 -P3306 -uroot -p123456 db_test --fields-terminated-by=',' user.csv --columns='id,name,sex,birthday,grades,address' --local
mysqlimport: [Warning] Using a password on the command line interface can be insecure.
db_test.user: Records: 7 Deleted: 0 Skipped: 0 Warnings: 2