What & How SQL Can Work?

SQL is a standard language for accessing database and can communicate for retrieving data.

Example: Select * From Table_name;

In this example SQL gives command to database for queried all data from particular table “table_name” and it derives out in a tabular form. 

What is and how SQL can works?

• SQL can execute queries beside a database.

• SQL can retrieve data from a database.

• SQL can insert, update and delete records in a database.

• SQL can create new database, new tables and schemas in a database.

• SQL can create stored procedures, functions and triggers in a database.

• SQL can create views can set permissions on tables, procedures, and views.

Following Commands are:

Select: Select * From Table_name;

Insert: INSERT INTO table_name

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

Update: UPDATE table_name

                 SET column1=value1, column2=value2...

                 WHERE column1=value1;

Delete: DELETE FROM Table_name

              WHERE column1=value1;