SQL Hosting Services

SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL statements are used to retrieve and update data in a database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc.

SQL is a standard computer language used for accessing and manipulating the database. It stands for Structured Query Language. With SQL allows we can to access a database, as SQL is an ANSI standard computer language, With SQL, we can execute queries against a database, can retrieve data from a database, insert new records in a database and can also update records in a database. SQL is very easy to use.

MySQL does not support features like stored procedures, triggers, referential integrity, and SQL unions and subqueries which are there in relational databases. So there are limitations to the environment in which it can be used.

But, it is well suited for Web applications.

Recently, MySQL added support for transactions; they are apparently at work now on stored procedures. That is why MySQL is an excellent product and getting better all the time.

Data Manipulation Language (DML)

SQL is a syntax for executing queries. But the SQL language also includes a syntax to update, insert, and delete records. These query and update commands together form the Data Manipulation Language (DML) which are a part of SQL part of SQL:

* SELECT command is used to extract data from a database table

* UPDATE command updates data in a database table

* DELETE is used to delete data from a database table

* INSERT INTO inserts new data into a database table

SQL Data Definition Language (DDL):

The Data Definition Language (DDL)is a part of SQL that allows the user to create or delete the database tables. We can also define indexes (keys), specify links between tables, and impose constraints between database tables.

The most important DDL statements in SQL are:

* CREATE TABLE – creates a new database table

* ALTER TABLE – alters (changes) a database table

* DROP TABLE – deletes a database table

* CREATE INDEX – creates an index (search key)

* DROP INDEX – deletes an index