Database Reference
In-Depth Information
Summary
You have many more possibilities when creating tables. There are options for setting differ-
ent types of storage engines. We touched on that in this chapter, but there's much more to
that. You can also create some tables with certain storage engines that will allow you to
partition the data across different locations on the server's hard drives. The storage engine
can have an impact on the table's performance. Some options and settings are rarely used,
but they're there for a reason. For now, we've covered enough options and possibilities
when creating tables.
What we have covered in this chapter may actually be a bit overwhelming, especially the
notion of reference tables like
bird_families
and
bird_orders
. Their purpose
should become clearer in time.
Chapter5
provides some clarification on tables, and will
show you how to alter them. There are additional examples of inserting and selecting data
interspersed throughout that chapter. Before moving on, make sure to complete the exer-
cises in the following section. They should help you to better understand how tables work
and are used.
