Re: Issue regarding the import of the date from csv file to the table in the database in mysql

[Mogens Melander]

I guess I'm sill learning.

Does that mean that, if the last column in a load blabla. is a 0000-00-00
terminated by ^n it might error ? Or are we talking ODBC ?

On Wed, November 14, 2012 18:58, hsv@stripped wrote:
>>>>> 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 0000/00/00,  now i need
> to get the date different(in days)
> between the dates present in the c1 and c2. That days should be shown in
> the c3. please help me out.
> <<<<<<<<
> Try DATEDIFF.
>
> As for date 0000/00/00, MySQL s treatment of NULLs in CSV files is
> peculiar: it wants the escape NULL or \N, separator right after separator
> is not NULL, but empty string. Consider those NULL.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>


-- 
Mogens Melander
[phone]

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.