21. Creating and Manipulating Tables
In this chapter you learn the basics of table creation, alteration, and deletion.
Creating Tables
MariaDB SQL statements are not used just for table data manipulation. Indeed, SQL statements can be used to perform all database and table operations, including the creation and manipulation of tables themselves.
There are generally two ways to create database tables:
• Using an administration tool (like the ones discussed in Chapter 2, “Introducing MariaDB”) that can be used to create and manage database tables interactively.
• Tables may also be manipulated directly with MariaDB SQL statements.
To create tables programmatically, the CREATE TABLE SQL statement is used. It is worth noting that when you use interactive ...
Get MariaDB Crash Course now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
