8.1

Integer Types

Types that represent positive and negative whole numbers.

Decimal Types

Types that represent numbers with fractional values.

Character Types

Types that represent textual data.

Time Types

Types that represent date and time or both.

Binary Types

Types that store data exactly as it appears in memory or files, bit for bit.

Semantic Types

Types based on other types but have a special meaning.

Collection Types

Types that include several distinct values of the same base type organized as a set or an array.

Document Types

Types that contain textual data in a structured format such as XML or JSON.

Spatial Types

Types that store geometric information such as lines, polygons, and map coordinates.

User-Defined Types

Types created by a database designer, as opposed to system-defined types.

System-Defined Types (Built-in Types)

Types provided by the database management system (DBMS) and reserved keywords.

CREATE TYPE Statement

A statement used to create user-defined types based on existing base types.

ENUM Type

A system-defined type that allows specifying a list of valid values for a column.

Composite Types

Types that can hold multiple values or subtypes, used in object-oriented programming.

MySQL

A database system that does not support the CREATE TYPE statement.

PostgreSQL

A database system that supports the CREATE TYPE statement.

Data Insertion

The process of inserting rows into a table, such as with the INSERT statement.