Flash and XML: A Developer's Guide

Syntax Now that we understand how a relational database is built, we are ready to learn how to operate it. The interface to a relational database...

To some degree, syntax is standard among all of the SQL DBMSs. There are many DBMSs available; the most popular are those published by Microsoft...

We start typing MySQL code at a command prompt. First, from the OS we have to log into our database. Typically we start at a...

One of the first things we learn to do in SQL is to create tables. It doesn't make any sense to try to store information...

The following suggestions make table creation easier. Always declare a primary key. The basis of relational databases is that each table has a way to...

There are several types of data: integers, floating-point numbers, strings, temporal measurements, and binary objects. There are several types of each kind of variable, each...

We created an empty table earlier in this chapter. But no matter how well defined, an empty table isn't very useful. We can add whatever...

Of course, storing data is useless unless we can recover it. MySQL gives us a powerful assortment of tools to retrieve and organize data. Select When...

With this material under our belts, we are ready to go out and build working database back ends. The ones we build for this book...