导出数据以table键分隔,导入格式如下:
LOAD DATA INFILE '/path' INTO TABLE tableName;
LOAD DATA INFILE '1109.txt' INTO TABLE data FIELDS TERMINATED BY ':' LINES TERMINATED BY '\n';
导出数据以table键分隔,导入格式如下:
LOAD DATA INFILE '/path' INTO TABLE tableName;
LOAD DATA INFILE '1109.txt' INTO TABLE data FIELDS TERMINATED BY ':' LINES TERMINATED BY '\n';