sql-parser
sql-parser copied to clipboard
Unexpected token because of missing space
This query, when formatted will give an unexpected token error because there's no space after LINES.
LOAD DATA INFILE 'filename' IGNORE INTO TABLE `db`.`table` FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (`column_1`, `column_2`);
https://user-images.githubusercontent.com/25424343/222931167-5b20214b-b1fd-4398-83e5-1d265d2fc363.mp4