Database Design Manual: using MySQL for Windows

• Main Author: Norman, Matthew (Author)
• Corporate Author: SpringerLink (Online service)
• Format: Electronic eBook
• Language: English
• Published: London : Springer London, 2004.
• Series: Springer Professional Computing
• Subjects: Computer science.; Programming languages (Electronic computers).; Database management.; Computer Science.; Programming Languages, Compilers, Interpreters.; Database Management.

Databases are now an integral part of the internet and many web sites use databases in the background to control their content. MySQL is one of the most commonly used open source database management systems. Due to it’s bundling with PHP, MySQL has proved a popular choice for many sites as it enable...

Table of Contents:

• MySQL and Databases
• Installing and Testing MySQL
• How Shall We Store it? — Datatypes
• Designing and Creating Tables
• Populating the Database
• Retrieving the Data
• Joining Tables
• Changing Data
• Deleting our Data
• Aggregate Functions
• Working with Dates and Times
• Securing the Database
• Optimizing MySQL
• Sharing MySQL data with MyODBC
• MySQL with PHP, Apache and Perl
• Making life easier.