Chapter 20. Creating Tables

20.1 Introduction

This chapter describes the statements for creating, updating, and deleting tables. We take the view that the user knows what data must be stored and what the structure of the data is—that is, what tables are to be created and what the appropriate columns are. In other words, the user has a ready-to-use database design at his or her disposal.

20.2 Creating New Tables

You can use the CREATE TABLE statement to construct new tables to store rows of data. The definition of this statement is complex and extensive. For that reason, we explain the statement’s features step by step and build up the definition slowly. The following sections and chapters explain the concepts of column definition, table integrity ...

Get SQL for MySQL Developers: A Comprehensive Tutorial and Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.