sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

Unexpected token because of missing space

Open liviuconcioiu opened this issue 2 years ago • 0 comments

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

liviuconcioiu avatar Mar 04 '23 22:03 liviuconcioiu