it-walker的博客

这是表数据展示 现在我用approval_item_id进行分组 每组按照时间倒序取最新一条 按照以前思路，先排序 order by，后进行group by SELECT * FROM (SELECT * FROM approval_record ORDER BY approval_item_id,create_time DESC) a GROUP BY approval_item_id; +----------------------------------+---------------------

问题1 Incorrect string value: ‘\xE6\xB5\x8B\xE8\xAF\x95’ for column ‘REASON’ at row 1 产生原因分析 从描述中看是出现中文字符集编码的问题,那么可以先尝试看下mysql5.7的默认字符编码集 mysql> show variables like 'char%'; +----------------------...