Creating Databases and Tables

Part of the MySQL course

Everything you did last lesson was look. You connected, browsed the system databases, and peeked inside a table that MySQL had already built for you. That is a fine way to get comfortable with the client, but it is not the same as having a place to put your own data.

Two ideas do all the work here. A database is a named container that groups related tables together, the way a folder groups related files. A table is the actual grid of rows and columns where data lives, one table per kind of thing you want to track: products, customers, orders. ...