Introduction
Text information
Boolean
Date and time
Summary

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');

Console

Code editor

Result

TableConsole