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
> <mog...@fumlersoft.dk>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.sag...@gmail.com> 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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
