See the MySQL warning message

When the King MySQL database import data often appear warning, these warnings are easy to ignore, today to the data when suddenly want to see what the warning content, Baidu a bit of MySQL view warning command

Show warnings;

The command is concise and a look at the general warning is like this

Warning | 1265 | Data truncated for column ' journal name ' at row 1265

There's one more thing.

| Warning | 1366 | Incorrect string value: ' \xb5\xda\xb6\xfe\xbd\xec ' for column ' journal name ' at row 1444 |

And there's this.

| Warning | 1366 | Incorrect integer value: ' For column ' work number ' at row 13 |

The more rare

| Warning | 1262 | Row one was truncated; It contained more data than there were input columns |

The MySQL warning is easy to understand, and it's easy to change the table with the warning message. In the above warning, the third is to insert an empty data, if the field allows null values, you can ignore these warnings, the second is the data character set is not correct. For the second encoding format that needs to modify the character set of the database or TXT that imports the data.

The first warning is that the field length is not enough, the imported data is automatically clipped by the system, and the fourth one is an extra column of imported data.

See the MySQL warning message