My Mistakes and Lessons Taught in Today's Learning
Today's learning
- Learning basics of SQL through PHPMyAdmin
(Solved by the following StackOverflow entry php - Invalid column count in CSV input on line 1 Error - Stack Overflow)
I made a table, then made its contents data by CSV format, and attempted to import the CSV.
At first I succeeded, but when I added a column onto the CSV, delete all data from the SQL table, and tried to import modified CSV data again.
It wasn't successful with an error message "Invalid column count in CSV input on line 1".
It was because I had forgotten adding new column to the database as well as I had just done with the CSV data.
- Learning basics of SQL through PHPMyAdmin
My Mistakes and Lessons in Today's Learning
1. Have I really added a column on my database table, as well as my data contents CSV?
- import failure with a message "Invalid column count in CSV input on line 1"(Solved by the following StackOverflow entry php - Invalid column count in CSV input on line 1 Error - Stack Overflow)
I made a table, then made its contents data by CSV format, and attempted to import the CSV.
At first I succeeded, but when I added a column onto the CSV, delete all data from the SQL table, and tried to import modified CSV data again.
It wasn't successful with an error message "Invalid column count in CSV input on line 1".
It was because I had forgotten adding new column to the database as well as I had just done with the CSV data.
Comments
Post a Comment