Fix Names in a SQL Table

PHOTO EMBED

Fri Sep 29 2023 17:17:33 GMT+0000 (Coordinated Universal Time)

Saved by @jaez #mysql

#Fixing names column so only first letter is uppercase.
Table: Users
+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| user_id        | int     |
| name           | varchar |
+----------------+---------+
  
select user_id,
CONCAT (UPPER(LEFT(name,1)),
LOWER(right(name,LENGTH(name)-1)))
as name from Users
ORDER BY user_id;
content_copyCOPY

https://leetcode.com/problems/fix-names-in-a-table/?envType=study-plan-v2&envId=30-days-of-pandas&lang=pythondata