Most of what an application does to its data is CRUD: create, read, update and delete, performed by INSERT, SELECT, UPDATE and DELETE. The examples run in the mysql client (mysql Client and Shell) against MySQL 9.7 524 with default settings, on the bookshop database used throughout the chapter. Watch the status lines: they tell you how many rows each statement really touched. Defining Tables covers table definitions and SELECT and Joins queries and joins in full.