Re: mysqlimport

[Jens Nickel <jens_(at)_kncag.com>]

hallo clemens

nachfolgend findest du das, was im mysql handbuch über "warnungen" steht.
etwas weiter unten steht dann ganz beiläufig, das vorgehen das dieter in
seiner antwort beschrieben hat.
eine andere möglichkeit gibt es gemäss handbuch nicht.
hoffe das dir das trotztdem etwas weiter hilft.

gruss jens

ab hier handbuch
....
Warnings indicates the number of attempts to insert column values that were
problematic in some way.
Warnings can occur under any of the following conditions:

Inserting NULL into a column that has been declared NOT NULL. The column is set
to its default value.
Setting a numeric column to a value that lies outside the column's range. The
value is clipped to the appropriate endpoint of the range.
Setting a numeric column to a value such as '10.34 a'. The trailing garbage is
stripped and the remaining numeric part is inserted. If the value doesn't make
sense as a number at all, the column is set to 0.
Inserting a string into a CHAR, VARCHAR, TEXT or BLOB column that exceeds the
column's maximum length. The value is truncated to the column's maximum length.

Inserting a value into a date or time column that is illegal for the column
type. The column is set to the appropriate ``zero'' value for the type.



---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql