MYSQL phpmyadmin import csv only first row
I was trying to import csv into mysql database through phpmyadmin
I had build the csv from excel, hence the delimited restriction. Click here to learn how to create csv from excel then how to import it into mysql. Just make sure .. that before importing you create and select the table in which the import is to happen.
Now I did all that and end result was that I could only import the first row.
The solution was that I added an extra column and filled it with the character ~
Then in phpmyadmin in “ field I entered ~
Problem Solved!
This was perfect! Thanks!
THE ~ SOLUTION DOESN’T WORK
it works, man! i struggled for hours. thank you.
Yes it works but needs a little head banging.