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 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.
