Monday (July 2' 2012)

These being the last 2 days for our theory classes, we were taught about Database Management. We were briefly introduced with MS Access and SQL. SQL stands for Structured Query Language and is a standard language for accessing databases. Now we know how to handle or manipulate data in MYSQL , SQL Server, ACCESS, etc.
           A database most often contains one or more tables. Several commands are used to handle queries or to insert, delete or show the entries in a table.

Example:-

The INSERT INTO Statement

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

SQL INSERT INTO Syntax-

INSERT INTO table_name VALUES (value1, value2, value3,...)

and the MySQL Command Line Client looks like ->