MySQL import data in CSV file, import only the first line

Importing CSV data with Workbench can only import the first row of data, that is, the row that labels the column names for each column.
However, the problem is that each time the import is complete, the system prompts that 500 records have been imported (there are 500 records in this file), but after the database is refreshed, the table is opened, which is still the only line mentioned above.

I also found in the Import Settings "field separator" that column, the operating system can only select semicolons, colons, TAB. In CSV, however, field and field are separated by commas.

Therefore, the following two points are mainly confirmed:

(1) Find out what your delimiter is. What is the system-supported delimiter, comma or semicolon? Is the delimiter of the CSV file consistent? Be sure to be consistent!
(2) Open your CSV content with the binary editor to see what the end of line breaks are. The line breaks produced by different operating systems are inconsistent, ensuring that the end of the line break is the same as the line break of the operating system!

MySQL import data in CSV file, import only the first line