代码:
- SubString(字段,1,end) - 从某个文本字段提取字符
# Write your MySQL query statement below
select user_id, concat(upper(substring(name,1,1)),lower(substring(name,2))) as name
from Users
order by user_id
代码:
# Write your MySQL query statement below
select user_id, concat(upper(substring(name,1,1)),lower(substring(name,2))) as name
from Users
order by user_id