What Next
You made it to the end. Well done.
You can now make tables, add rows, ask questions, join data, and keep writes safe.
What you learned
Databases, tables, rows, and types
INSERT, SELECT, UPDATE, DELETE
WHERE, LIKE, IN, BETWEEN, ORDER BY, LIMIT
Keys, joins, groups, and indexes
Views, subqueries, and transactions
A small project
Build a fox library. Tables for books, readers, and loans.
Insert a few rows. Ask who borrowed what. Find overdue loans with a date compare.
Query OK, 0 rows affected
Query OK, 0 rows affected
Keep going on FoxSchools
Python is a great next language for talking to MySQL. Try the Python course.
Web apps often sit on MySQL too. The JavaScript course helps there.
Thank you for learning with us. Go store something that matters.
Remember: SQL is a request. Say what you want. Let MySQL walk the shelves.
Test yourself
Three quick questions made just for this lesson. Earn 10 XP per correct answer.