Part III. Creating Database Objects
This third part describes how database objects are created. Database object is the generic term for, among other things, tables, keys, views, and indexes. These are the objects that we must create and that together form a database.
Chapter 20, “Creating Tables,” describes all the statements for creating tables and details the properties of the different data types.
When tables are created, it is possible to specify integrity constraints. Chapter 21, “Specifying Integrity Constraints,” explains these constraints and also reviews primary keys, alternate keys, foreign keys, and check integrity constraints, along with some other topics.
Chapter 22, “Character Sets and Collations,” explains the terms character set ...
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.
