MySQL Forums
Forum List  »  Newbie

Posted by: Lokith raj
Date: March 06, 2011 09:59AM

HI ,
I have got struck with load data syntax,

When i load the data which is converted from the xl sheet into csv file in comma delimiter format, cetain fields like middle name, Addressline3 holds null

ie John, , ,London

In between 2 values are null ,
in this case how can i load these null values into my table....

And another one doubt,

When i use DATE datatype it doesn't support 01/01/01 format,,,
how to use the datatype to get the above format while loading or creating the table,,,

could you please reply,

Options: ReplyQuote

Written By
March 06, 2011 09:59AM
March 07, 2011 02:21AM

Sorry, you can't reply to this topic. It has been closed.

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.