Great! In this part, we'll show you what data types are used for text information.
Text information is a data type that can store words and expressions like 'barbecue', 'Hannah Smith' or 'Maroon5'.
In SQL, text information is always stored between two single quotation marks (i.e., ', also called 'single quotes' or 'apostrophes'). They are important because they tell our database 'Hey, this is text information!'.
Do you still remember Peter from the previous 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 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. It contains 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 How to INSERT, UPDATE, and DELETE Data in SQL course.
Here's the syntax:
INSERT INTO ... VALUES (...);
