List:General Discussion« Previous MessageNext Message »
From:sagar bs Date:November 14 2012 9:23am
Subject:Re: Issue regarding the import of the date from csv file to the table
in the database in mysql
View as plain text  
tried to import data as text, but its showing Operation failed with
exitcode 1

On Wed, Nov 14, 2012 at 1:12 PM, Mogens Melander <mogens@stripped>wrote:

> Or you could import the date as text and convert dates using:
>
> mysql> SELECT STR_TO_DATE('04/31/2004', '%m/%d/%Y');
>     -> '2004-04-31'
>
>
> On Wed, November 14, 2012 06:13, Larry Martell wrote:
> > 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, ....
>
>
> --
> Mogens Melander
> +66 8701 33224
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>


-- 
Regards

SAGAR B S

Thread
Issue regarding the import of the date from csv file to the table inthe database in mysqlsagar bs14 Nov
  • Re: Issue regarding the import of the date from csv file to the tablein the database in mysqlLarry Martell14 Nov
  • Re: Issue regarding the import of the date from csv file tothe table in the database in mysqlhsv14 Nov
    • Re: Issue regarding the import of the date from csv file to the tablein the database in mysqlsagar bs14 Nov
      • Re: Issue regarding the import of the date from csv file tothe table in the database in mysqlhsv14 Nov
        • Re: Issue regarding the import of the date from csv file to the table in the database in mysqlMogens Melander14 Nov
          • Re: Issue regarding the import of the date from csv file tothe table in the database in mysqlhsv15 Nov
Re: Issue regarding the import of the date from csv file to the table in the database in mysqlMogens Melander14 Nov
  • Re: Issue regarding the import of the date from csv file to the tablein the database in mysqlsagar bs14 Nov
Re: Issue regarding the import of the date from csv file to the table in the database in mysqlMogens Melander14 Nov
Re: Issue regarding the import of the date from csv file to the table in the database in mysqlMogens Melander14 Nov
  • Re: Issue regarding the import of the date from csv file to the table in the database in mysqlMogens Melander14 Nov