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);
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);