🗄️ Databases
CREATE TABLE — Building Your Blueprint
Before you store any data, you need to create a table — a blueprint with column names and types. Think of a table like a spreadsheet sheet: you define the columns (name, age, score) and then fill in the rows. The main types are TEXT, INTEGER, REAL (decimal), and BLOB (files).
3 min 10 XP Lesson 2 of 11
Before you store any data, you need to create a table — a blueprint with column names and types. Think of a table like a spreadsheet sheet: you define the columns (name, age, score) and then fill in the rows. The main types are TEXT, INTEGER, REAL (decimal), and BLOB (files).
Quick Quiz
What does PRIMARY KEY AUTOINCREMENT do?