Question

Data truncation: Data too long for column 'content' at row 1 Query

Posted March 28, 2021 79 views
Databases

database mysql8

How to set SQL MODE fix this error?

-
MySQL will truncate any insert value that exceeds the specified column width.
to make this without error try Switch your MySQL mode to not use STRICT.

意思大概是MySQL将截断超过指定列宽度的任何插入值。为了让这个不报错,你可以尝试切换你的MySQL模式不使用严格模式。

Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!