Latest blog on category "MYSQL"

The demand for the SQL professionals who are also endowed with sharp analytical thinking skills which can be applied to SQL is never less....

 149 View(s)

A view is a SQL statement which is stored in the database with a name. A view is actually a formation of a table in the form of a predefined Structured Query Language (SQL) query....

 1083 View(s)

Triggers are store procedure, which are automatically executed or fired when some events occur like deletion, insertion of data. Triggers are database object which is attached to a table and is executed automatically....

 1156 View(s)

Constraints are used to apply some rules for the record in a table. If any rule is violated between constraint and data, then the action is aborted by the constraint....

 1237 View(s)

In previous article we have discussed about SQL and some queries. In this part we will continue on SQL Queries:...

 979 View(s)

SQL stands for Structured Query Language. The structured query language is used to manipulate and access the databases. SQL is an ANSI (American National Standard Institute) standard....

 1070 View(s)

These functions return a single value, calculated from the values in the column.Scalar functions return a single value, based on input data. Following are the various types of scalar functions....

 1040 View(s)