Re: Secure File Privilege

[Peter Brawley]

With your table on a Windows machine where secure_file_prov="c:/in", this Load Data cmd works ...

LOAD DATA INFILE 'c:/in/aisle.csv'
INTO TABLE aisle
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';

select * from aisle;
+---------+------------------+
| idaisle | aisleDescription |
+---------+------------------+
|       1 | 1                |
|       2 | 2                |
|       3 | 3                |
|       4 | 4                |
|       5 | 5                |
|       6 | 6                |
|       7 | 7                |
|       8 | 8                |
|       9 | 9                |
+---------+------------------+