Logo
Pattern

Discover published sets by community

Explore tens of thousands of sets crafted by our community.

SQL Data Types

15

Flashcards

0/15

Still learning
StarStarStarStar

DATETIME

StarStarStarStar

A data type used for storing date and time information. Example: event_start DATETIME

StarStarStarStar

CHAR

StarStarStarStar

A fixed-length string data type. Example: gender CHAR(1)

StarStarStarStar

BLOB

StarStarStarStar

A data type used to store binary large objects, such as images or files. Example: user_image BLOB

StarStarStarStar

DATE

StarStarStarStar

A data type used to store dates in the format YYYY-MM-DD. Example: birth_date DATE

StarStarStarStar

TIME

StarStarStarStar

A data type for storing times without date information. Example: opening_time TIME

StarStarStarStar

BOOLEAN

StarStarStarStar

A data type used to store true or false values. Example: is_active BOOLEAN

StarStarStarStar

TIMESTAMP

StarStarStarStar

A data type for storing date and time, often used for tracking changes. Example: last_updated TIMESTAMP

StarStarStarStar

BIT

StarStarStarStar

A data type used to store bit-field values. Example: permissions BIT(3)

StarStarStarStar

VARCHAR

StarStarStarStar

A variable-length string data type. Example: name VARCHAR(255)

StarStarStarStar

DOUBLE

StarStarStarStar

A data type for decimal numbers that requires more precision than FLOAT. Example: salary DOUBLE

StarStarStarStar

TEXT

StarStarStarStar

A data type for storing long-form text strings. Example: comments TEXT

StarStarStarStar

INT

StarStarStarStar

A data type used to store whole numbers. Example: age INT

StarStarStarStar

ENUM

StarStarStarStar

A data type that allows for a value to be one from a set of predefined strings. Example: shirt_size ENUM('small', 'medium', 'large')

StarStarStarStar

FLOAT

StarStarStarStar

A data type used to store decimal numbers with floating-point precision. Example: height FLOAT

StarStarStarStar

DECIMAL

StarStarStarStar

A fixed-point number data type used for storing exact numeric values. Example: product_rating DECIMAL(3,2)

Know
0
Still learning
Click to flip
Know
0
Logo

© Hypatia.Tech. 2024 All rights reserved.