目前,我正在尝试删除MySQL 5.7 (InnoDB)中的重复行,并通过运行SELECT COLUMN, COUNT(*) FROM TABLE GROUP BY COLUMN HAVING COUNT(*) > 1来检查是否有多少重复的mediumtext列。表的字符集是utf8mb4,正在聚合的列的排序规则是utf8mb4_general_ci。
: Data truncation: Data too long for column 'TOKEN_SCOPE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
atcom.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.jav