UPPER and LOWER in MySQL - Step-by-Step Execution

Concept Flow - UPPER and LOWER

Start with input string

↓

Convert all

↓

letters to

↓

uppercase

↓

Return converted string

↓

End

The flow starts with an input string, then chooses either UPPER or LOWER function to convert all letters to uppercase or lowercase, and finally returns the converted string.

Execution Sample

MySQL

SELECT UPPER('Hello World') AS upper_text,
       LOWER('Hello World') AS lower_text;

This query converts the string 'Hello World' to uppercase and lowercase, showing both results.

Execution Table

Step	Function Called	Input String	Output String
1	UPPER	'Hello World'	'HELLO WORLD'
2	LOWER	'Hello World'	'hello world'
3	END	-	-

💡 Both functions processed the input string and returned the converted strings; execution ends.

Variable Tracker

Variable	Start	After Step 1	After Step 2	Final
input_string	'Hello World'	'Hello World'	'Hello World'	'Hello World'
upper_text	NULL	'HELLO WORLD'	'HELLO WORLD'	'HELLO WORLD'
lower_text	NULL	NULL	'hello world'	'hello world'

Key Moments - 2 Insights

Why does the input string not change after calling UPPER or LOWER?

The input string remains unchanged because UPPER and LOWER return new converted strings without modifying the original input, as shown in execution_table steps 1 and 2.

Can UPPER and LOWER affect non-letter characters like spaces or numbers?

No, UPPER and LOWER only change letter characters; spaces, numbers, and symbols remain the same, which is why 'Hello World' keeps the space unchanged in the output.

Visual Quiz - 3 Questions

Look at the execution table, what is the output of UPPER at step 1?

A 'HELLO WORLD'

B 'hello world'

C 'Hello World'

D 'HELLO world'

💡 Hint

Check the Output String column in execution_table row with Step 1.

At which step does LOWER function produce its output?

A Step 1

B Step 2

C Step 3

D No output produced

💡 Hint

Look at the Function Called column in execution_table to find when LOWER is called.

If the input string was '123 ABC xyz', what would LOWER('123 ABC xyz') return?

A '123 abc XYZ'

B '123 ABC XYZ'

C '123 abc xyz'

D '123 ABC xyz'

💡 Hint

LOWER converts letters to lowercase but leaves numbers unchanged, as seen in variable_tracker.

Concept Snapshot

UPPER(string) converts all letters in string to uppercase.
LOWER(string) converts all letters in string to lowercase.
Non-letter characters remain unchanged.
Both return new strings without modifying the original.
Use in SELECT to display converted text.

Full Transcript

This visual execution trace shows how the MySQL functions UPPER and LOWER work. Starting with the input string 'Hello World', the UPPER function converts all letters to uppercase, resulting in 'HELLO WORLD'. The LOWER function converts all letters to lowercase, resulting in 'hello world'. The input string itself does not change. Non-letter characters like spaces remain the same. The execution table tracks each step, showing the function called, input, and output. The variable tracker shows how variables change after each step. Key moments clarify common confusions, such as why the input string stays the same and how non-letter characters are unaffected. The quiz questions help reinforce understanding by referencing the execution visuals. The concept snapshot summarizes the key points for quick review.