This note explains the
following topics: Creating and Deleting a Database, Setting the Default
Database, Inserting Rows, Querying the Database, Producing Summary Reports,
Modifying Data, Deleting Rows, Loading/Exporting Data from/to a Text File,
Running a SQL Script, More Than One Tables, Primary Key, Foreign Key and Index.
MySQL is a free, open-source database engine available for all major platforms. (Technically, MySQL is a
relational database management system (RDBMS).) MySQL represents an excellent introduction to modern
database technology, as well as being a reliable mainstream database resource for
high-volume applications. The contents include: Introduction, First Steps, Make a Database, Make a Table,
Advanced Database Queries 1: People, Advanced Database Queries 2: ZIP Codes.
This note explains the
following topics: Creating and Deleting a Database, Setting the Default
Database, Inserting Rows, Querying the Database, Producing Summary Reports,
Modifying Data, Deleting Rows, Loading/Exporting Data from/to a Text File,
Running a SQL Script, More Than One Tables, Primary Key, Foreign Key and Index.