Chapter 12, Problem 55E

Program Plan Intro

SQL:

• The full form of SQL is “Structured Query Language”.
• 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.
• Some of the DBMS products provide GUI tools in order to perform tasks are as follows:
  • SQL Server
  • Oracle Database
  • MySQL

INSERT INTO:

“INSERT INTO” statement helps to insert values into the existing table. The syntax to insert values into the table is as follows.

INSERT INTO Table_Name (ColumnName) Values (value1, value 2, …);