Database - DML

DML - Data Manipulation Language

Select statement

The SELECT statement is used to select data from a database.

   The result is stored in a result table, called the result-set.

Syntax:

SELECT column_name(s)

FROM table_name

Insert statement  

    The INSERT INTO statement is used to insert a new row or record in a table.

Syntax:

 It is possible to write the INSERT INTO statement in two forms.

  The first form doesnt specify the column names where the data will be inserted,

 only their values:

INSERT INTO table_name

VALUES (value1, value2, value3,...)

The second form specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1, column2, column3,...)

VALUES (value1, value2, value3,...)

delete statemet

   The DELETE statement is used to delete rows or records in a table.

syntax:

       DELETE FROM table_name

       WHERE some_column=some_value

update statement

  The UPDATE statement is used to update existing records in a table.

Syntax:

UPDATE table_name

SET column1=value, column2=value2,...

WHERE some_column=some_value