Re: Loading table from CSV - Help required
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
Subject
Written By
Posted
February 02, 2009 08:20PM
February 02, 2009 08:36PM
February 02, 2009 08:58PM
February 02, 2009 09:10PM
February 03, 2009 09:45AM
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.