MySQL: where is log-warnings file?

Report · Mar 11, 2008

hi:

OS X 10.4.10
Server version: 4.1.21-standard
MySQL client version: 5.0.24a

i imported a CSV file into a table using LOAD DATA. everything seems ok
but the operation reported some warnings i'd like to check

=====================================================================
mysql> LOAD DATA LOCAL INFILE '/DATA/.../authors-3_unix_utf8.csv' INTO
TABLE authors_new FIELDS TERMINATED BY ';';

Query OK, 249 rows affected, 11 warnings (0.03 sec)
Records: 249 Deleted: 0 Skipped: 0 Warnings: 11
=====================================================================

tia,

jdoe

Report · Mar 11, 2008

.oO(John Doe)

>OS X 10.4.10
>Server version: 4.1.21-standard
>MySQL client version: 5.0.24a
>
>i imported a CSV file into a table using LOAD DATA. everything seems ok
>but the operation reported some warnings i'd like to check
>
>=====================================================================
>mysql> LOAD DATA LOCAL INFILE '/DATA/.../authors-3_unix_utf8.csv' INTO
>TABLE authors_new FIELDS TERMINATED BY ';';
>
>Query OK, 249 rows affected, 11 warnings (0.03 sec)
>Records: 249 Deleted: 0 Skipped: 0 Warnings: 11
>=====================================================================

Try a

SHOW WARNINGS;

after the first query.

Micha

Report · Mar 11, 2008

thanks a lot Micha, it did the trick!

mysql> SHOW WARNINGS;
+---------+------+---------------------------------------------------------------+
| Level | Code | Message
|
+---------+------+---------------------------------------------------------------+
| Warning | 1265 | Data truncated for column 'removed' at row 30
|
| Warning | 1265 | Data truncated for column 'removed' at row 63
|
| Warning | 1265 | Data truncated for column 'surname' at row 71

Michael Fesser wrote:
> .oO(John Doe)
>
>> OS X 10.4.10
>> Server version: 4.1.21-standard
>> MySQL client version: 5.0.24a
>>
>> i imported a CSV file into a table using LOAD DATA. everything seems ok
>> but the operation reported some warnings i'd like to check
>>
>> =====================================================================
>> mysql> LOAD DATA LOCAL INFILE '/DATA/.../authors-3_unix_utf8.csv' INTO
>> TABLE authors_new FIELDS TERMINATED BY ';';
>>
>> Query OK, 249 rows affected, 11 warnings (0.03 sec)
>> Records: 249 Deleted: 0 Skipped: 0 Warnings: 11
>> =====================================================================
>
> Try a
>
> SHOW WARNINGS;
>
> after the first query.
>
> Micha

Report · Mar 11, 2008

.oO(John Doe)

>thanks a lot Micha, it did the trick!

You're welcome.

Micha