1, pymysql.err.DataError: (1406, "Data too long for column 'url' at row 1")
字段设置的类型长度不够
2,pymysql 1146-table doesn't exit的问题
使用pymysql 前数据库中要先建表和字段
3, InternalError: (1366, u"Incorrect string value: '\\xF0\\x9F\\x90\\x98\\xE8\\ ......
1、将已经建好的表也转换成utf8mb4
命令:alter table TABLE_NAME convert to character set utf8mb4 collate utf8mb4_bin; (将TABLE_NAME替换成你的表名)
2、数据库链接
conn=pymysql.connect(
host='127.0.0.1',
port=3306,
user='root',
passwd='123456',
db='db1',
charset='utf8mb4',
)