Sql Insert, Update, Delete Statements

Posted by

Sql Insert, Update, Delete Statements

sql crud

Image credit:upload.wikimedia.org

The data manipulation operations such as Sql Insert, Update, Delete Statements are also termed as CRUD operations.
We have already discussed a lot about Select statement(s) in our previous post. Here, we will discuss about Insert,Update and Delete statements which perform operations on the data within the table(s) within the database(s).

The concept of creating or altering the Data Structure is known as Data Definition but if it is used only to operate on the records of the data within the table structures, it is called Data Manipulation. Therefore, we can say that the Data Definition defines the data and their types and the Data Manipulation is a term associated with the operations on the values contained within these data.
CRUD is also relevant at the user interface level of most applications. For example, in address book software, the basic storage unit is an individual contact entry. As a bare minimum, the software must allow the user to:

Create or add new entries
Read, retrieve, search, or view existing entries
Update or edit existing entries
Delete/deactivate existing entries
Without at least these four operations, the software cannot be considered complete. Because these operations are so fundamental, they are often documented and described under one comprehensive heading, such as “contact management”, “content management” or “contact maintenance” (or “document management” in general, depending on the basic storage unit for the particular application).

Detailed examples about Insert statement

Detailed examples about Update statement

Facebook Comments

Syed Adeel Ahmed
Analyst, Programmer, Educationist and Blogger at Technofranchise
Computer Systems Engineer from Sir Syed University Of Engineering & Technology.I am passionate about all types of programming.
Syed Adeel Ahmed on FacebookSyed Adeel Ahmed on GoogleSyed Adeel Ahmed on InstagramSyed Adeel Ahmed on Twitter