如何用load data infile导入数据

1.mysql -u root -p
    password

2.use mydb

3.LOAD DATA INFILE "/home/mark/data.csv" INTO TABLE Users FIELDS TERMINATED BY ',' ;

data.csv
name,password,1

其他:
使用本地文件导入到服务器上的MYSQL:
LOAD DATA LOCAL INFILE "C:/data.csv" INTO TABLE users;

避免导入数据
LOAD DATA LOW_PRIORITY INFILE "/home/user/data.sql" REPLACE INTO TABLE users;

导入数据文件以逗号分隔,以双引号结束
LOAD DATA INFILE "/home/mark/Orders.txt" REPLACE INTO TABLE Orders FIELDS TERMINATED BY ',' ENCLOSED BY '"';

导入指定的列
LOAD DATA INFILE "/home/data.txt" INTO TABLEUsers(username, password, active);