Explore tens of thousands of sets crafted by our community.
SQL Data Types
15
Flashcards
0/15
DATETIME
A data type used for storing date and time information. Example: event_start DATETIME
CHAR
A fixed-length string data type. Example: gender CHAR(1)
BLOB
A data type used to store binary large objects, such as images or files. Example: user_image BLOB
DATE
A data type used to store dates in the format YYYY-MM-DD. Example: birth_date DATE
TIME
A data type for storing times without date information. Example: opening_time TIME
BOOLEAN
A data type used to store true or false values. Example: is_active BOOLEAN
TIMESTAMP
A data type for storing date and time, often used for tracking changes. Example: last_updated TIMESTAMP
BIT
A data type used to store bit-field values. Example: permissions BIT(3)
VARCHAR
A variable-length string data type. Example: name VARCHAR(255)
DOUBLE
A data type for decimal numbers that requires more precision than FLOAT. Example: salary DOUBLE
TEXT
A data type for storing long-form text strings. Example: comments TEXT
INT
A data type used to store whole numbers. Example: age INT
ENUM
A data type that allows for a value to be one from a set of predefined strings. Example: shirt_size ENUM('small', 'medium', 'large')
FLOAT
A data type used to store decimal numbers with floating-point precision. Example: height FLOAT
DECIMAL
A fixed-point number data type used for storing exact numeric values. Example: product_rating DECIMAL(3,2)
© Hypatia.Tech. 2024 All rights reserved.