首页 > 数据库 >插入MySQL报错‘pymysql.err.DataError: (1406, "Data too long for column 'url' at row 1"

插入MySQL报错‘pymysql.err.DataError: (1406, "Data too long for column 'url' at row 1"

时间:2022-11-11 23:01:02浏览次数:44  
标签:DataError err column pymysql 报错 long MySQL row

错误重现:

插入MySQL报错‘pymysql.err.DataError: (1406, "Data too long for column 'url' at row 1")’

解决方法:

在插入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.

 

标签:DataError,err,column,pymysql,报错,long,MySQL,row
From: https://www.cnblogs.com/xfbk/p/16882320.html

相关文章