[go: up one dir, main page]
Scribd
Upload
145 views2 pages

The SQL Select Statement

The document discusses four SQL statements: SELECT, INSERT INTO, UPDATE, and DELETE. The SELECT statement is used to select data from a database and store it in a result table. The INSERT INTO statement inserts new records into a table, specifying column names and values. The UPDATE statement modifies existing records by setting column values. The DELETE statement removes existing records using a condition such as an ID number.

Uploaded by

Richard Melvin Garcia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
145 views2 pages

The SQL Select Statement

The document discusses four SQL statements: SELECT, INSERT INTO, UPDATE, and DELETE. The SELECT statement is used to select data from a database and store it in a result table. The INSERT INTO statement inserts new records into a table, specifying column names and values. The UPDATE statement modifies existing records by setting column values. The DELETE statement removes existing records using a condition such as an ID number.

Uploaded by

Richard Melvin Garcia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

The SQL SELECT Statement

The SELECT statement is used to select data from a database.

The data returned is stored in a result table, called the result-set.

SELECT Syntax
SELECT column1, column2, ...
FROM table_name;
Here, column1, column2, ... are the field names of the table you want to select data from. If you
want to select all the fields available in the table, use the following syntax:
SELECT * FROM table_name;

The SQL INSERT INTO Statement

The INSERT INTO statement is used to insert new records in a table.

INSERT INTO Syntax

It is possible to write the INSERT INTO statement in two ways.

The first way specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1, column2, column3, ...)


VALUES (value1, value2, value3, ...);

If you are adding values for all the columns of the table, you do not need to specify the column
names in the SQL query. However, make sure the order of the values is in the same order as the
columns in the table. The INSERT INTO syntax would be as follows:
INSERT INTO table_name
VALUES (value1, value2, value3, ...);

The SQL UPDATE Statement

The UPDATE statement is used to modify the existing records in a table.

UPDATE Syntax
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

The most commonly used condition is the id number or unique key:

e.g. WHERE id = ‘R290344’

The SQL DELETE Statement

The DELETE statement is used to delete existing records in a table.

DELETE Syntax
DELETE FROM table_name
WHERE condition;

The most commonly used condition is the id number or unique key:

e.g. WHERE id = ‘R290344’

You might also like