Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.1. A copy of the license is included in the section entitled “GNU Free Documentation License”
- Introduction
- Introduction in MySQL for Other Applications
- Installation
- Installation in MySQL for Other Applications
- Working with data
- If you are using Sequel Pro, go to the “Query” tab. If you are using the command line, make sure you are in the mysql command line, and remember to end your statements with semicolons.
- Manipulating Data
- Manipulating Data in MySQL for Other Applications
- Multiple tables
- Where modern databases start to get both more confusing and more useful is when you start making multiple tables and link them together. For example, we now have a list of all of our albums, why not a list of all of the songs as well?
- MySQL for Other Applications: Security
- Most of the work we do with MySQL is for the web. Whether you use Dreamweaver or PHP or any other means of displaying MySQL data on the web, your username and password must be embedded in your web files and readable to the web server.
- Other Applications
- MySQL is often used with other applications to display data. For data on the web, Dreamweaver, PHP, Python, and Perl are probably the most common methods used. The PHP, Python, and Perl examples here assume that you already know how to use those programming languages.
- More Information
- More Information in MySQL for Other Applications
- MySQL for Other Applications (full HTML) (92.4 KB)
- HTML version of MySQL for Other Applications
- MySQL for Other Applications (full PDF) (1.7 MB)
- PDF version of MySQL for Other Applications
- MySQL for Other Applications (full RTF) (1.7 MB)
- RTF version of MySQL for Other Applications
- ZIP Resources for MySQL for Other Applications (2.1 MB)
- Resources for MySQL for Other Applications, including samples and document graphics.
More MySQL
- Adding PDO_MYSQL to Mac OS X Leopard Server
- There’s “a feature request with engineering to include pdo_mysql” in Mac OS X Server. Fortunately, adding it is only moderately complex.