Database Reference
In-Depth Information
| Warning | 1265 | Data truncated for column 'col3' at row
1 |
...
You can execute the
SHOW WARNINGS
statement to get a list of the warnings. Because
there were 209,249 warnings, I've listed only a few of them here, just the ones for the first
row. The warnings for all of the other rows are about the same. Most of these warnings
appeared because we have columns using the
CHAR
data type with a width of 0. This
means that any data in the fields that corresponds to those columns will contain more data
than it can hold. In such cases, the data is truncated upon being loaded into the table and
the server generates a warning for each such column. Let's look at a sample of the data in
the table to see more clearly what the warnings are trying to tell us and how well the state-
ment did:
SELECT * FROM rookery.clements_list_import LIMIT 2 \G;
*************************** 1. row ***************************
id: 0
change_type: Clements 6.9 change
col2:
col3:
scientific_name: Scientific name
english_name: English name
col6:
order: Order
family: Family
col9:
col10:
col12:
col13:
col14:
col15:
col16:
col17:
*************************** 2. row ***************************
id: 1
change_type:
col2:
col3:
scientific_name: Struthio camelus
english_name: Ostrich
col6:
order: Struthioniformes
family: Struthionidae (Ostrich)
col9:
