PENGELOMPOKAN STATEMEN SQL

PENGELOMPOKAN STATEMEN SQL
1. Data Definition Language (DDL)
CREATE DATABASE             DROP DATABASE
CREATE TABEL                     DROP TABEL
CREATE INDEX                     DROP INDEX
CREATE VIEW                       DROP VIEW
ALTER TABLE

2. Data Manipulation Language
INSERT, SELECT, UPDATE, DELETE

3. Data Access
GRANT , REVOKE

4. Data Integrity
RECOVER TABLE

5. Auxiliary
SELECT INTO OUTFILE,
LOAD, RENAME TABLE