mysql一条sql怎么统计某个字段不同值的个数？1. 先查验是否是自己想要的结果SELECT concat(LEFT(name, CHAR_LENGTH(name) -1), 4) FROM userinfo2. 更新update userinfo set name = concat(LEFT(name, CHAR_LENGTH(name) -1), 4)
