编写解决方案,修复名字,使得只有第一个字符是大写的,其余都是小写的。
select
user_id,
concat(upper(left(name,1)),lower(substr(name,2))) as name
from
Users
order by
user_id
编写解决方案,修复名字,使得只有第一个字符是大写的,其余都是小写的。
select
user_id,
concat(upper(left(name,1)),lower(substr(name,2))) as name
from
Users
order by
user_id