Chapter 3, Problem 3.44RQ

Program Plan Intro

SQL:

• SQL stands for “Structured Query Language”.
• The current version of SQL is “ANSI SQL – 92”.
• SQL is not a programming language. It is text-based and it is also called as data sublanguage.
  • In order to get SQL as a complete programming language, it should be included in scripting languages like Java, C#, and so on.
• It contains constructs which are used to define and process database. They are executed using DBMS-supplied command prompt.
• Some of the DBMS products provide GUI tools in order to perform tasks are as follows:
  •  SQL Server
  • Oracle Database
  • MySQL

UPDATE statement:

It is possible to update information into a table with the help of “UPDATE…SET” statement. Replacing an existing value with a new value can also be done.

Note: It is necessary to use “WHERE” clause when updating values, because, when it is ignored all the values from the mentioned column name gets changed.

Syntax:

UPDATE table_Name SET columnName1 = value WHERE condition;