SQL statements are used to access and manipulate data in a database.
SQL Data Manipulation Language (DML)
SQL (Structured Query Language) is a language used to execute queries. SQL Data Manipulation Language (DML) includes statements to retrieve, update, insert and delete records.
Important SQL DML Statements:
|SELECT||Retrieves data from a table.|
|UPDATE||Updates data in a table.|
|DELETE||Deletes data from a table.|
|INSERT INTO||Inserts new data into a table.|
|CREATE TABLE||Creates a new table.|
|CREATE INDEX||Creates a new index.|
|ALTER TABLE||Modifies a table.|
|DROP TABLE||Deletes a table.|
|DROP INDEX||Deletes an index.|