Deep Dive on Creating MySQL Tables
Taking a close look at the CREATE TABLE Statement
Issue: 11.1 (November/December 2012)
Author: Craig Boyd
Article Description: No description available.
Article Length (in bytes): 4,447
Starting Page Number: 87
RBD Number: 11113
Resource File(s): None
Related Link(s): None
Known Limitations: None
Excerpt of article text...
When it comes to databases, a number of us care about only what we absolutely have to: tables, primary keys, schemas, and indexes. After that, our concern about other aspects of the database tend to drop off rather quickly. Part of the reason is because we are developers and not DBAs. That is not a criticism, but just a simple statement of fact. A number of us are consultants with customers who depend on us for help in keeping the systems we have installed up and running. For some, installing the database involves taking all the defaults, running the install scripts we have come up with for our application and then setting up the application. For small installations that is certainly not a bad approach and in fact may even be the recommended approach. But sometimes we have clients who have employee numbers in the hundreds or perhaps even more. For that reason, having a better understanding of how databases work can be immensely helpful.
Since nearly half of the developers surveyed by Real Software a while back use MySQL, that is the DBMS I am planning to focus on. Over the next few, maybe several, columns I want to do a deep dive into several aspects of the CREATE TABLE statement, what they mean and how they can be used.
...End of Excerpt. Please purchase the magazine to read the full article.
Article copyrighted by REALbasic Developer magazine. All rights reserved.