How to Import a CSV File into MySQL Without an ID Field?

Importing a CSV File into MySQL Without an ID Field

The issue arises when attempting to import a CSV file into a MySQL table that lacks an ID field and lacks column headers. This guide will provide instructions on how to import the data while skipping the first column (ID) and allowing MySQL to automatically assign values to the auto-increment ID field.

Steps:

1. Open phpMyAdmin and navigate to the table you wish to import data into.
2. Click on the "Import" tab.
3. In the "File to import" field, select the CSV file you wish to import.
4. Under "Database," select the database containing the target table.
5. Under "Table," select the target table.
6. Check the "Ignore lines terminated with n (carriage return line feed)" box.
7. Click on the "Fields terminated by" dropdown and select "," (comma).
8. Leave the "Fields enclosed by" field empty.
9. Leave the "Fields escaped by" field empty.
10. Click on the "Lines terminated by" dropdown and select "auto."
11. In the "SQL query," enter the following command:

LOAD DATA INFILE 'path/to/file.csv' INTO TABLE your_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' SET>

Replace 'path/to/file.csv' with the actual path to your CSV file. Replace 'your_table' with the name of the target table.

12. Click on the "Go" button to start the import process.

Note: Ensure that the ID field in your table is set to auto-increment before performing the import. This will allow MySQL to automatically assign unique values to the ID column for each imported record.

The above is the detailed content of How to Import a CSV File into MySQL Without an ID Field?. For more information, please follow other related articles on the PHP Chinese website!