SQL commands based on their nature:
These commands can be classified into groups based on their nature:
DDL Commands (Data Definition Language)
CREATE Creates a new table or other object in database.
ALTER Modifies an existing database object.
DROP Deletes an entire table or other object in the database.
DML Commands (Data Manipulation Language)
SELECT Retrieves records from one or more tables.
INSERT Insert a record into the table.
UPDATE Modifies records.
DELETE Deletes records.
DCL Commands (Data Control Language)
GRANT Gives a privilege to user.
REVOKE Takes back privileges granted from user.
Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....
Conversion Conversion Emoticon Emoticon