MySQL Forums
Forum List  »  Newbie

Re: Loading table from CSV - Help required
Posted by: kalpna garg
Date: March 03, 2009 12:38AM

The result set is : +--------+---------------+------------+
| emp_no | emp_name | doj |
+--------+---------------+------------+
| 1 | Sam,Daniel | 2008-11-01 |
| 2 | Jennifer,Jane | 2008-05-11 |
| 4 | David,Alfred | 0000-00-00 |


while the actual data for emp_no 4 is 4,"David,Alfred",2008-13-11.

Is it beacause of mysql dafault date format(yyyy-mm-dd) that result set shows doj as 0000-00-00

Options: ReplyQuote


Subject
Written By
Posted
Re: Loading table from CSV - Help required
March 03, 2009 12:38AM


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.