MySQL Forums :: Newbie :: LOAD DATA


Advanced Search

LOAD DATA
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


Subject Written By Posted
LOAD DATA Lokith raj 03/06/2011 09:59AM
Re: LOAD DATA Devart Team 03/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.