MySQL Cookbook, 2nd Edition

Introduction

This chapter covers topics that relate to creating and populating tables:

• Cloning a table

• Copying one table to another

• Using temporary tables

• Generating unique table names

• Determining what storage engine a table uses or converting a table to use a different storage engine

To create and load the mail table used for examples in this chapter, change location into the tables directory of the recipes distribution, and run this command:

%mysql cookbook < mail.sql