1. Home
  2. Docs
  3. MySQL
  4. 更新-update

更新-update

update users set users = CASE WHEN nikcname LIKE "%" THEN substring_index(nikcname, '.', 3) else null END; # 复制同一个表字段并截取字符

Was this article helpful to you? Yes No

How can we help?