LOAD DATA LOCAL INFILE '/Users/dxm/Desktop/task' INTO TABLE `mg_task` FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (id, phone);
mysql 命令导入数据。以csv 导入。
LOAD DATA LOCAL INFILE '/Users/dxm/Desktop/task' INTO TABLE `mg_task` FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (id, phone);
mysql 命令导入数据。以csv 导入。