var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Load data local infile
I have a raw file like below,
It has a lot of white spaces after each and every row.
Is there a way to ignore those white spaces while loading the data ?
or do I have to mention it like
LINES TERMINATED BY ', \n'
Thanks in advance for your help !
You could remove the blank lines first, example:Remove empty lines with sed
Or tell "load data" to only include certain lines, example: https://coderwall.com/p/0nnaiq
Tags for this Thread