SQL Commands


SQL can be divided into two parts: SQL Data Manipulation Language (DML)
The query and update commands form the DML part of SQL: SQL Data Definition Language (DDL)
The DDL part of SQL permits database tables to be created or deleted. It also define indexes (keys), specify links between tables, and impose constraints between tables. The most important DDL statements in SQL are Using SQL in Your Web Site
To build a database-driven web site, the following is needed at least:

Demonstration
Below is an SQL test area from W3Schools, which uses the well-known Northwind sample database. The tables here are for read only because of the problem of embedding the scripts. For a fully working example, check this by using Chrome.

SQL Statement:

Edit the SQL statement and click     to see the result, or  

Result:
The Database includes:
The Database includes:

TablenameRecord
Customers91
Categories8
Employees10
OrderDetails518
Orders196
Products77
Shippers3
Suppliers29





      Man 1: Your kid just looks like you.    
      Man 2: Shhh, not so loud. That’s next door lady’s kid.