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
List-Archive: http://lists.mysql.com/mysql/228611
Message-Id: <CACwCsY7q4NL8VAK_Nmorhb2Hs7HSfCjX+sdmbTpiUT==v-xtNw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8

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, ....