CREATE, ALTER and DROP Statements in MySQL

Q

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.

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

Drop an Existing Index in MySQL

Create a New View in MySQL

Drop an Existing View 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.

 

⇒⇒MySQL Database Tutorials

2016-10-17, 235👍, 0💬