|List:||General Discussion||« Previous MessageNext Message »|
|From:||Mogens Melander||Date:||November 14 2012 11:30pm|
|Subject:||Re: Issue regarding the import of the date from csv file to the |
table in the database in mysql
|View as plain text|
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.