weixin_40425145的博客

DECIMAL(M,N):注意，N是小数点后面的位数，M-N为小数点前面的位数

设置MySQL事务锁超时时间查看：SHOW GLOBAL VARIABLES LIKE ‘innodb_lock_wait_timeout’;设置：SET GLOBAL innodb_lock_wait_timeout=1500;

pymysql.err.InternalError: (1366, "Incorrect string value: '\xF0\x9报错1.ALTER TABLE main_snak CONVERT TO CHARACTER SET utf8mb4;2.连接数据库时 charset=‘utf8mb4’

Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails (wikidata.descriptions, CONSTRAINT entity_id_descriptions FOREIGN KEY (entity_id) REFERENCES wikidata (id))解决方法：...