MySQL Programming Question:

How Many SQL DDL Commands Are Supported by "mysql"?

Tweet Share WhatsApp

Answer:

There are 4 SQL Data Definition Language (DDL) commands that are supported by "mysql". They are listed below with short descriptions:

► "CREATE dataObjectType dataObjectName" - Creates new databases, tables, views, triggers, indexes, and other data objects.
► "RENAME dataObjectType dataObjectName" - Renames existing databases, tables, views, triggers, indexes, and other data objects.
► "ALTER dataObjectType dataObjectName" - Alters properties of existing databases, tables, views, triggers, indexes, and other data objects.
► "DROP dataObjectType dataObjectName" - Drops existing databases, tables, views, triggers, indexes, and other data objects.

Here is a tutorial exercise of how to use DDL commands to create a database and a table:

>cd mysqlin
>mysql -u root

mysql> CREATE DATABASE ggl;
Query OK, 1 row affected (0.50 sec)

mysql> CREATE TABLE articles (name VARCHAR(80));
Query OK, 0 rows affected (0.25 sec)

mysql> DROP DATABASE ggl;
Query OK, 0 rows affected (0.41 sec)

Download MySQL Programming PDF Read All 110 MySQL Programming Questions
Previous QuestionNext Question
What Are the "mysql" Command Line Arguments?How Many SQL DML Commands Are Supported by "mysql"?