King^Lully: CSV -> Array -> SQL

Beitrag lesen

Du siehst das Problem besteht eigentlich daran den Importerfolg der Daten "transaktional" sicherzustellen.

Aha - obwohl ich fast nichts von dem verstehe was Du schreibst werde ich mich mal versuchen durchzukämpfen.

Danke vorerst :)

Es geht darum sicherzustellen, dass Du die Daten entweder en bloc importierst oder eben gar nicht importierst, oder?

Beachte auch:
"
When the LOAD DATA INFILE statement finishes, it returns an information string in the following format:

Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
If you are using the C API, you can get information about the statement by calling the mysql_info() function. See Section 22.2.3.35, “mysql_info()”.

Warnings occur under the same circumstances as when values are inserted via the INSERT statement (see Section 13.2.4, “INSERT Syntax”), except that LOAD DATA INFILE also generates warnings when there are too few or too many fields in the input row. The warnings are not stored anywhere; the number of warnings can be used only as an indication of whether everything went well.

You can use SHOW WARNINGS to get a list of the first max_error_count warnings as information about what went wrong. See Section 13.5.4.28, “SHOW WARNINGS Syntax”.
"