Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Tables in SQL

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