前述
SQL中字符串截取函数(SUBSTRING)
SQL 字母大小写转换函数UPPER()、UCASE()、LOWER()和LCASE()
题目描述
leetcode题目:1667. 修复表中的名字
Code
select user_id, concat(
upper(substring(name, 1, 1)),
lower(substring(name, 2))
) as name
from Users
order by user_id
SQL中字符串截取函数(SUBSTRING)
SQL 字母大小写转换函数UPPER()、UCASE()、LOWER()和LCASE()
leetcode题目:1667. 修复表中的名字
select user_id, concat(
upper(substring(name, 1, 1)),
lower(substring(name, 2))
) as name
from Users
order by user_id