更新-update update users set users = CASE WHEN nikcname LIKE "%" THEN substring_index(nikcname, '.', 3) else null END; # 复制同一个表字段并截取字符 Doc navigation← 统计分析主从同步 → Was this article helpful to you? Yes No How can we help? Name Email subject message