Implementation of the sql statement include DDL, DML and DCL

Previously had little in the pillowcase on what it DDL, DML and DCL.

Here everything will be discussed in more detail:

1. DDL (Data Definition Language)

DDL is the SQL command associated with defining a database structure that is used to create, modify and delete metadata structures and definitions of database objects.

Some basic commands that include DDL include:

A. CREATE

This command is used to create, including creating a new database, the new table, new view, and column.

B. ALTER

This command is used to change the table structure has been created. Her work includes replacing the name of the table, add column, alter column, delete columns, as well as to attribute to the column.

C. RENAME

The command used to change the name of the Object

D. DROP

This command is used to delete databases and tables.

implementation:

2. DML (Data Manipulation Language)

DML is a SQL command that is used for the processing of the data contents in the table as insert, modify and delete the contents of the data - and not associated with changes in the structure and definitions of data types of database objects.

SQL commands that are included in DML among others:

A. UPDATE

This command is used to update old data into the latest data. If you have data that is incorrect or insufficient Up To Date with the present conditions, the contents of the data can be changed by using the UPDATE command.

B. INSERT

This command is used to insert or insert new data into the table. Its use as a database and tables finished.

C. SELECT

This command is used to retrieve data or display data from a table or tables in the relationship. Data taken can we show in the screen prompt MySQL directly and displayed on the display application.

D. DELETE

This command is used to delete data from a table. Usually the deleted data is data that is not needed anymore. At the time of erasing data, commands that have been executed can not be frustrated, so that the data that has been lost can not be restored anymore.

3. DCL (Data Control Language)

DCL is an SQL command associated with the manipulation of user and access rights (priviledges).

SQL commands that are included in DCL, among others:

A. GRANT

This command is used to provide rights / permissions by the administrator (principal owner) server to the user (regular users). The access rights such as the right to make (CREATE), take (SELECT), menghapsu (DELETE), change (UPDATE) and special rights with regard to the system database.

B. REVOKE

This command has reversed with GRAND uses, namely to eliminate or deprive aksesyang has been given to the user by the administrator.

implementation:

References :

http://naura-lab.blogspot.co.id/2015/01/bagaimana-cara-menggunakan-select.html
Sistem Basis Data,Utami Ema | Anggit Dwi Hartanto, 2012, Yoyakarta, Andi.