I am trying to load data into mysql database form text file.
LOAD DATA LOCAL INFILE 'P:\file.txt' INTO TABLE table_january
FIELDS TERMINATED BY '\t'
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
> error code: 1148. The used command is note allowed with this MySQL
MySQL version 8.0.19.
Asked by Djacy Neto
(1 rep)
Feb 19, 2020, 10:05 PM
Last activity: Jun 24, 2025, 01:01 PM
Last activity: Jun 24, 2025, 01:01 PM