Introduction
Text information
Boolean
Date and time
Summary

Instruction

Great! We'll start off with text information. This is a data type which we can use to store words and expressions like 'barbecue', 'Hannah Smith' or 'Maroon5'.

In SQL, text information is always stored between two single quotation marks '(apostrophes). They are important, because they tell our database 'Hey, this is text information!'.

Exercise

Do you still remember Peter from the first part of our course and his childhood museum? Well, his idea didn't really work out. He now has a new idea in mind - an online dating website! In this part of the course, we're going to help him develop this new brilliant idea.

He hasn't done much so far. There is only a single table user_account in his database with a single column named nickname. Let's practice working with text information by putting his first user Kangaroo19 into the table. Remember about the quotation marks!

If you don't remember how to insert data into tables, check out our course about operating on data in SQL.

Stuck? Here's a hint!

Type

INSERT INTO user_account VALUES ('Kangaroo19');

Console

Code editor

Result

TableConsole