I have a csv file that i want to create a database from. Now everything works fine except for the date that is now stored in a VARCHAR column.
Is it possible to make it so that the date get stored in a DATE column when i import it from my phpMyAdmin? The csv looks like this:
Date,HomeTeam,AwayTeam,FTHG,FTAG,FTR,HTHG,HTAG,HTR 29-09-2017,Excelsior,Vitesse,0,3,A,0,1,A 30-09-2017,Heracles,Feyenoord,2,4,A,0,3,A 30-09-2017,Willem II,Den Haag,1,2,A,0,1,A