🗃️Row
Also known as Record, Database Row
One record in a table. It holds all the facts about one thing.
Think of it like
Think of it like one line in a class list. It holds all the facts on one pupil.
Example
When Lucy signs up, a new row is added to the customers table. It holds her id, her name and her city.
Why it matters
Rows are the real data. Each sign-up, sale and message becomes a new row.
Definition
Example code
sql
INSERT INTO customers (name, city)
VALUES ('Lucy', 'Lisbon');Common mistake
Key takeaways
- 1One thing. A customer, an order, a message.
- 2A value per column. Even if it is empty.
- 3Insert, update, delete. The three ways rows change.