I'm building an app to import data from a text file to a database.
I want to import only specific lines from the text file. With Navicat I found that we could limit number of line when importing data.
I also found an article saying that we could limit it, so I tried this:
load data infile 'c:/coop/wkwk.txt' into table jo fields terminated by '|' lines terminated by '\n' limit 10,100;
But I get an error in
SQL syntax, what is the
QUERY to make this work?