Question :
I upload the csv file which has more than 5 thousand rows table data for option import wizard by Mysql Workbench. As the result the output table only 335 rows, have no idea how to overcome the limitation.
Answer :
It all comes down to the contents of your CSV-file – and that in turn is determined by the used program that created it in the first place …
Check if all lines have the desired number of values per line, in combination with:
Check if escape-characters (if any) are there .. and you give them in mysql-workbench as well …
special case for Microsoft Excel – it used to create ONE escape sequence for first occurance, 2 Escape sequences for 2nd occurance and so forth … I had to use a php-script to import them, where I had to hand-twiddle until mysql was satisfied with the input-format
compare those successful lines with other lines in the csv – What is the difference between them?