Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 14 in printed book and digital formats -- plus a one-year subscription so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview

Buy Now



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.




Weblog Commenting and Trackback by HaloScan.com