CREATE, ALTER and DROP Statements in MySQL
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL?
✍: FYIcenter.com
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.
What Are DDL Statements in MySQL
CREATE TABLE Statement in MySQL
CREATE Command Denied Error in MySQL
Show All Tables in a Database in MySQL
Show All Columns of an Existing Table in MySQL
Show CREATE TABLE Statements of Existing Tables in MySQL
Creating New Tables with SELECT Statements in MySQL
Add a New Column to an Existing Table in MySQL
Delete an Existing Column in a Table in MySQL
Rename an Existing Column in a Table in MySQL
Rename an Existing Table in MySQL
Drop an Existing Table in MySQL
Create an Index for a Given Table in MySQL
Show All Indexes of a given Table in MySQL
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.
2018-03-13, 653👍, 0💬