Syntax:
LOAD DATA LOCAL INFILE ‘absolute path’
INTO TABLE table-name
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\n’
IGNORE 1 ROWS;
IF the local modifier is ignored, it access the file on the server.
OS X Import data from local file to MySQL
最新推荐文章于 2023-07-31 17:02:22 发布