Introduction
Text information
Numbers
Date and time
Instruction
Good job! Now, let's experiment a bit. We told you that char(10) always takes 10 characters (unlike varchar(10), which can store 10 characters or fewer). Let's see what happens if we provide a shorter value.
Exercise
Peter wants to know what happens when a new user doesn't comply with the rule about 10-character-long nicknames. Try to add a new user Adrian whose nickname is soap27.
Stuck? Here's a hint!
Type:
INSERT INTO user_account VALUES ('Adrian', 'soap27');
