|List:||General Discussion||« Previous MessageNext Message »|
|From:||Mogens Melander||Date:||November 14 2012 9:44am|
|Subject:||Re: Issue regarding the import of the date from csv file to the |
table in the database in mysql
|View as plain text|
Did you change the target column to varchar before import ? On Wed, November 14, 2012 10:23, sagar bs wrote: > 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 > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > -- Mogens Melander +66 8701 33224 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.