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. As you can see, nothing particular happened - the row was added successfully. This is because the limit set for varchar defines the maximum number of characters - but it can be anything shorter than that too!

How about longer values? Let's find out.

Exercise

The longest last name in history is probably that of a German typesetter: Wolfeschlegelsteinhausenbergerdorff. Someone on the website, called Adam, thought it would make a perfect nickname. Will the 35-character-long nickname work? Try to add it to the table user_account.

Stuck? Here's a hint!

Type

INSERT INTO user_account VALUES ('Adam', 'Wolfeschlegelsteinhausenbergerdorff');