MySQL Forums
Forum List  »  German

Advanced Search
New Topic

Incorrect date value
Posted by: Franz Reiter
Date: August 10, 2011 06:20AM

Hallo, ich habe mehrere Tabellen mit Datumfeldern. Beispiel:
Field | Type | Null | Key | Default | Extra
------+------+------+-----+---------+--------
... | ... | ... | ...| ... |
ud | date | YES | | NULL |
------+------+------+-----+---------+--------
Ich will nun mit mysqlimport Daten in die Tabelle(n) laden.
Das entsprechende Feld in der Datendatei hat häufig NULL-Werte.
Das müsste doch trotzdem gehen? Was kann ich machen?

Error: 1292, Incorrect date value: '' for column 'ud' at row 1, when using table: yz

mysql Ver 14.14 Distrib 5.5.14, for Win32

Vielen Dank

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Incorrect date value
2164
Franz Reiter
August 10, 2011 06:20AM


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.