Sql Tutorial (Structured Query Language): Four types of sql queries

In this article we are going to learn sql queries which are the most important part of every part every websites which uses databases on their site such as dynamic websites.

After making connection to database via script or manually, Usually four types of work is done on database,

  • Insert
  • Retrieve,
  • Update,
  • Delete,

Queries that do such modification in database are written below:

/* Insert query */
" INSERT INTO table_name (attribute1, attribute2) 
VALUES ('value1', 'value2')"
/*insert query ends */

/* retrieve Query */
" SELECT * FROM table_name WHERE attribute='value_stored_in_table'
ORDER BY table_attribute 
LIMIT starting_value, No_of_rows_to_be_displayed "
/* retrieve query ends */

/* update query */
" UPDATE table_name 
SET attribute1='any value', attribute2='any value'
 WHERE attribute='value_stored_in_table' "
/* update query ends */

/* Delete query */
" DELETE FROM table name 
WHERE attribute='value_stored_in_table' "
/* Delete query ends */
sql girl
sql girl

Insert query is used to Insert new row into the database, Retrieve Query to retrieve/select data from database, Update query for inserting new data by replacing the older values and Delete query to delete a row from the database table. Some of the important points are displayed below:

  • "WHERE" clause specifies the condition or select the row in database tables on which data modifications is to be done,
  • "ORDER BY" clause specifies the condition in what order data should be modified or selected according to a particular attribute(this attribute of table must be set to auto-increment in database while creating table) of database table,
  • We can use "ASC" and "DESC" in retrieve query to order retrieved rows in ascending and descending order, like this: ORDER BY table_attribute ASC.
  • "LIMIT" clause set the number of rows that should be modified in database tables while setting the starting value Like this "LIMIT 0, 30" - Here "0" is the starting value and data starting from zero until 30 rows reached will be selected and then modifications will be done on it.
  • "value_stored_in_table" refer to the value that is already stored in a particular row of the database table, You should change this according to your needs.
  • "SET" clause in update query is used to set the new values of attribute of a particular row and will replace the already stored values in row of database table.

More by this Author


Comments 3 comments

itech profile image

itech 6 years ago from New Delhi, India Author

Thanks gauri, You're most welcome.


SQL training 5 years ago

How to create a multiple database in SQL server 2005? Is that possible?


Vignesh 4 years ago

thanks dude

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working