SQL Vocabulary
SMALLINT
A 16-bit integer (-32768 to 32767).
INTEGER or INT
A 32-bit integer (-2147483648 to 2147483647).
query
A SQL command which retrieves data based on specific criteria.
INSERT
A SQL statement used to add data to a database table.
CREATE TABLE
A SQL statement used to construct new tables in a relational database.
UPDATE
A SQL statement used to modify data in a database.
DELETE
A SQL statement used to remove data from a database.
SELECT
A SQL statement used to retrieve data from a database.
SQL Injection
A code injection technique, used to attack data driven applications, in which malicious SQL statements are inserted into an entry field for execution.
statement
A command issued to a relational database, which may have a persistent effect on schemata and data, or which may control transactions, program flow, connections, sessions, or diagnostics.
TIMESTAMP
A date and time combination stored as the number of seconds since the epoch (January 1, 1970).
TIME
A date and time combination.
DATE
A date.
DOUBLE
A normal-size (double-precision) floating-point number.
WHERE clause
A portion of a SQL statement used to filter records.
FLOAT
A small (single-precision) floating-point number.
SQL
A special-purpose programming language designed for managing data held in a relational database management system (RDBMS).
NUMERIC(precision
A type which stores exact numeric data values, such as for currency.
predicate
Component of a SQL command which specifies conditions that can be evaluated and which are used to limit the effects of statements and queries, or to change program flow.
expression
Component of a SQL statement which can produce either scalar values, or tables consisting of columns and rows of data.
clause
Constituent component of a statement or query.
CHARACTER(n) or CHAR(n)
Fixed-width n-character string, padded with spaces as needed.
CHARACTER VARYING(n) or VARCHAR(n)
Variable-width string with a maximum size of n characters.
BOOL or BOOLEAN
Zero or one (TRUE or FALSE)
BIT(n)
an array of n bits.
