2012/11/15 00:30 +0100, Mogens Melander
I guess I'm sill learning.
Does that mean that, if the last column in a load blabla. is a -00-00
terminated by ^n it might error ? Or are we talking ODBC ?
Find it under LOAD DATA
If an empty field is parsed for a NOT NULL DATE o
6:40 AM: Sorry, didn't mean to be rude. It's in there.
On Thu, November 15, 2012 00:23, Mogens Melander wrote:
> Dude, which part of RTFM did yoy miss?
>
> http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
>
> On Wed, November 14, 2012 13:57, sagar bs wrote:
>> Hi,
>>
>>
>> There
I guess I'm sill learning.
Does that mean that, if the last column in a load blabla. is a -00-00
terminated by ^n it might error ? Or are we talking ODBC ?
On Wed, November 14, 2012 18:58, h...@tbbs.net wrote:
> 2012/11/14 18:27 +0530, sagar bs
> There are four columns in my table n
Dude, which part of RTFM did yoy miss?
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
On Wed, November 14, 2012 13:57, sagar bs wrote:
> Hi,
>
>
> There are four columns in my table named like account_name, c1, c2 and
> c3.
> Account name is the primary key and c1, c2 contai
2012/11/14 18:27 +0530, sagar bs
There are four columns in my table named like account_name, c1, c2 and c3.
Account name is the primary key and c1, c2 contain two different dates and in
the column c2 there are few fields showing /00/00, now i need to get the
date different(in da
Hi,
There are four columns in my table named like account_name, c1, c2 and c3.
Account name is the primary key and c1, c2 contain two different dates and
in the column c2 there are few fields showing /00/00, now i need to
get the date different(in days)
between the dates present in the c1
2012/11/14 10:26 +0530, sagar bs
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/ and mysql takes
the date format like /mm/dd.
The number of variables in the csv file are same in the table
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
> wrote:
>
>> Or you could import the date as text an
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 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, Novem
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 wrote:
>> Hi,
>>
>> As i have the data with some 25 variables
On Tue, Nov 13, 2012 at 9:56 PM, sagar bs 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/ and mysql takes
> the date format like /mm/dd.
> The number of variables in the csv f
11 matches
Mail list logo
