SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘已消毒‘ for column ‘sfxd‘ at row 1

问题截图如下:
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘已消毒‘ for column ‘sfxd‘ at row 1
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘已消毒‘ for column ‘sfxd‘ at row 1
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘已消毒‘ for column ‘sfxd‘ at row 1
错误原因分析: 数据类型错误。
修正: 将sfxd字段类型由tinyint改为varchar 10。
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘已消毒‘ for column ‘sfxd‘ at row 1

上一篇:MySql Lock wait timeout exceeded 解决办法


下一篇:mysql字符集