在插入MySQL的字符太多,此时将MySQL的模式改为非严格模式。
MySQL中运行:
mysql> SET @@global.sql_mode= ‘’;
【搬运国外大神解释】
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的模式改为非严格模式。
MySQL中运行:
mysql> SET @@global.sql_mode= ‘’;
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报错‘pymysql.err.DataError:
本文链接:https://www.haomeiwen.com/subject/ptebdqtx.html
网友评论