|List:||General Discussion||« Previous MessageNext Message »|
|From:||Larry Martell||Date:||November 14 2012 5:13am|
|Subject:||Re: Issue regarding the import of the date from csv file to the table|
in the database in mysql
|View as plain text|
On Tue, Nov 13, 2012 at 9:56 PM, sagar bs <bs.sagar1@stripped> wrote: > Hi, > > As i have the data with some 25 variables in csv file and i need to import > to mysql. > The issue is that the date format in csv file is dd/mm/yyyy and mysql takes > the date format like yyyy/mm/dd. > The number of variables in the csv file are same in the table in database > of mysql. > Please help me out. Convert the data in your CSV file into the format you need. So many ways to do that, e.g.: bring in into excel and change the column's format, use sed, use python, use vi, ....