MySQL Crash Course, 2nd Edition

21

Creating and Manipulating Tables

In this chapter, you’ll learn the basics of table creation, alteration, and deletion.

Creating Tables

MySQL statements are not used just for table data manipulation. Indeed, MySQL can be used to perform all database and table operations, including to create and manipulate tables.

There are generally two ways to create database tables:

• You can use an administration tool (like the ones discussed in Chapter 2, “Introducing MySQL”) to create and manage database tables interactively.

• You can manipulate tables directly with MySQL statements.

To create tables programmatically, you use the CREATE TABLE SQL statement. It is worth noting that when you use interactive tools, you are actually using MySQL statements. ...