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
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.