| A query
like this : |
|
| Last Name |
| Hansen |
| Svendson |
| Pettersen |
|
|
|
Note: Some database
systems require a semicolon at the end of the SQL statement.
We don't use the semicolon in our tutorials..
|
|
| SQL Data Manipulation Language
(DML) : |
|
|
SQL (Structured Query Language) is a
syntax for executing queries. But the SQL language also
includes a syntax to update, insert, and delete records.
|
|
|
These query and update commands together
form the Data Manipulation Language (DML) part of SQL.
|
|
- SELECT - extracts data from a database table
- UPDATE - updates data in a database table
- DELETE - deletes data from a database table
- INSERT INTO - inserts new data into a database table
|
|
| SQL Data Definition Language
(DDL) : |
| |
|
The Data Definition Language (DDL) part
of SQL permits database tables to be created or deleted.
We can also define indexes (keys), specify links between
tables, and impose constraints between database tables.
|
|
|
|
« BACK |
NEXT »
|
| Need more answers; Search Google |
|
|
CREATING SOFTWARE ASSETS
Home
