LU04a - Syntax of DML

As we know, SQL stands for Structured Query Language. Consequently, It should come as no surprise that SQL is indeed consistently structured.

Please note that the use og CAPITAL LETTERS for SQL commands and tabs can make it easier for you to maintain your program code.

Every SQL query is composed by three main commands:

• SELECT column1, column2, …
• FROM myTable
• WHERE myCondition.

With SELECT you specify which columns you want to have output; with FROM you specify the TABLE from which the columns originate; and with WHERE you specify the condition under which the data records are selected. Where does not have to occur if there is no condition.

Let us take a table with some customers like in below picture. To get all information, which are stored in this table, our SQL command would be like

SELECT * FROM customers;

Volkan Demir