Lessons Importing CSV’s into PHPMYADMIN
I’ve been working on building dummy data into my local database. Uploading a CSV that I filled with data using Excel, I populated my database. Here are two lessons I learned.
For one of the fields that I didn’t populate with data, imported a 0 because it was an integer field. However, I needed the field null. When I went into the record and took out the 0 and tried to save it, I got an error. What I found was that when I clicked the checkbox for null for the record, it nullified the field.
The date format was the European format in my database YYYY-MM-DD. However, when I had the dates in the American format in my CSV MM-DD-YYYY. The records imported successfully in my database, but instead of erring out with the data, it set the date to 0000-00-00. So I just had to delete the imported records, and then edit the date format in the CSV and re-import.