[MySQL] Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 0.000 sec

박해인·2024년 8월 15일
0

Error

목록 보기
4/16
  1. 경로확인
    SHOW VARIABLES LIKE 'secure_file_priv';

  2. LOAD DATA INFILE '/secure_file_priv_directory/your_file.csv'
    INTO TABLE your_table
    FIELDS TERMINATED BY ','
    ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
    IGNORE 1 ROWS;

profile
갓생살고싶어라

0개의 댓글