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

Excellent! As you can see, Peter didn't really spend much time writing the statement!

Let's focus on the varchar limit we put in the table for both columns: varchar(32). What will happen if a nickname is shorter than that? Let's find out.

Exercise

Try to add a person named Anna with a nickname crazygirl to the table user_account.

Stuck? Here's a hint!

Type

INSERT INTO user_account VALUES ('Anna', 'crazygirl');