FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
LeetCode-Solutions/MySQL/fix-names-in-a-table.sql at master · feiyunwill/LeetCode-Solutions · GitHub
feiyunwill
LeetCode-Solutions
Repository navigation
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
LeetCode-Solutions
/
MySQL
/
fix-names-in-a-table.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
6 lines (5 loc) · 153 Bytes
Breadcrumbs
LeetCode-Solutions
/
MySQL
/
fix-names-in-a-table.sql
Copy path
File metadata and controls
6 lines (5 loc) · 153 Bytes
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
#
Time: O(nlogn)
#
Space: O(n)
SELECT
user_id, CONCAT(
UPPER
(
SUBSTRING
(name,
1
,
1
)),
LOWER
(
SUBSTRING
(name,
2
)))
AS
name
FROM
Activity
ORDER BY
user_id;
Back
|
FazBrowse Home
|
New Git URL