DDL IN MY SQL WITH EXAMPLES

Explain DDL COMMAND IN MY SQL WITH EXAMPLES

Data Definition Language:

What is DDL data definition language explain with examples.
Data Definition Language deals with database schemas and descriptions of how the data should reside in the database, therefore language statements like CREATE TABLE or ALTER TABLE belong to DDL. DML deals with data manipulation, and therefore includes most common SQL statements such SELECT, INSERT, etc. Data Control Language includes commands such as GRANT, and mostly concerns with rights, permissions and other controls of the database system.

DDL are used for: 

* Create Databse
* Create Table
* Insert Value In Table
* Display Table Value
* Drop Table
* Add Column in Row
* Add Values in Columns & Rows
* Delete Column
* Delete Some Rows
* Alter Table

Tweet