MySQL problem set

1. Data Import

Error: 1265, data truncated for column 'column name' at Row 1

Show variables like 'SQL _ Mode'

Strict_trans_tables, no_auto_create_user, no_engine_substitution

Solution:

Set @ Global. SQL _mode = 'no _ auto_create_user, no_engine_substitution'

Explanation: If strict_trans_tables cannot insert the given value into the transaction table, the statement is abandoned. For non-transaction tables, if the value appears in the 1st rows of a single-row or multi-row statement, the statement is discarded. A more detailed description is provided later in this section.
No_auto_create_user prevents grant from automatically creating new users unless a password is specified. No_engine_substitution

If the required storage engine is disabled or not compiled, the storage engine cannot be replaced automatically.