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 covers the
following topics: History of MySQL, Features and Benefits, Entering Basic
Queries, Creating and Using a Database, MySQL: Architecture, MySQL: Workbench,
Installing MySQL, Connecting and Disconnetting to or from MySQL.