This Tutorial

- Introduction

- The MySQL database

- Using SQL to create a MySQL database

- Using SQL to access MySQL databases

- Creating tables

- Using SQL to describe MySQL database tables

Related Pages

Microsoft Access Workgroup tutorial

Microsoft Access Database Splitter tutorial

Microsoft Access Build Your Own Database manual

- SQL tutorial for Microsoft Access

- SQL tutorial for SQL Server

SQL database comparisons

- Comparison of the commands and operators used in WHERE clauses in Oracle, Microsoft Access, MySQL and SQL Server, and how to limit the number of rows returned

- Comparison of useful functions in Oracle, MySQL, Microsoft Access and SQL Server

Useful links

Microsoft Access

ASP Free site has a series of articles for beginners. Novices should start with the "Getting to Know ... " articles..

Alan Browne's tips contains tutorials suitable for all levels of expertise from casual users to Access developers.

Microsoft: This link will take you to the Microsoft Access Developer Center, from which you can find code samples, tutorials and tips.

MySQL

Download the MySQL database from the MySQL AB site.

Knowledge base articles and user manual are also available from the MySQL AB site..

The PHP MySQL Tutorial site covers the basic procedures for new PHP-MySQL programmers.

Structured Query Language (SQL) tutorial

Using SQL to Describe MySQL Database Tables

Describing tables

MySQL provides a command that displays the column details of the tables.

• Issue the following command at the mysql prompt:

   DESCRIBE booking;

The display should be as follows:

DESCRIBE lists all the column names along with the table's column types.

Now let's see how we can insert data into our table.

What’s next?

In this chapter, you have learnt the basics of database and table creation using SQL.  Following from this, you will discover how to add data to tables, and to extract information from this data.