Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Text information
Numbers
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');