Where to find answers to frequently asked questions on
CREATE, ALTER and DROP Statements in MySQL?

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team
on CREATE, ALTER and DROP Statements in MySQL.
Clear answers are provided with tutorial exercises on creating, altering and dropping tables, indexes, and views; adding, renaming, and dropping table columns.

Please note that all answers and tutorials are based on MySQL 5.0. Tutorial exercises
should be executed with "mysql" or other MySQL client programs. It is also assumed that
you have a MySQL user account and a predefined database with enough privileges.

Some sample scripts requires database tables created by other samples in the beginning of the collection.