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

Source: Internet
Author: User
Tags mysql import

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.