2023/03/03

Leetcode Note: MySQL - Fix Names in a Table

Fix Names in a Table - LeetCode
https://leetcode.com/problems/fix-names-in-a-table/

MySQL で取り組んだメモ

回答

Detailed explanation of QUERY and Functions that are required to solve this - Fix Names in a Table - LeetCode
https://leetcode.com/problems/fix-names-in-a-table/solutions/1963494/detailed-explanation-of-query-and-functions-that-are-required-to-solve-this/

SELECT Users.user_id, CONCAT(
        UPPER(SUBSTR(Users.name,1,1)),
        LOWER(SUBSTR(Users.name,2))
    ) AS name 
    FROM Users
    ORDER BY
        Users.user_id ASC