O'Reilly logo

Getting Started with MariaDB by Daniel Bartholomew

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating, altering, and dropping tables

Databases contain tables. Tables are two-dimensional data structures containing rows and columns. A row corresponds to a single record in a database and records are divided into columns. Think of database tables like a specialized spreadsheet.

The many multiple tables in a MariaDB database have columns, which can relate in one way or another. For example, the id column in an employee table may relate to the employee_id column in an address table. These relationships (also called foreign keys ) are why we call MariaDB a relational database.

A database without tables of data is nothing more than a name. Until we create some tables and start adding data to those tables, our database is empty and useless.

Creating ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required