Home >> SQL >> Enum Data Types in SQL

Enum Data Types in SQL

ENUM data type provide an efficient way to define columns that can contain only a given set of values.

ENUM values must be one of those listed in the column definition, or the internal numeric equivalent there of. A column defined as ENUM('a','b','c') value.

Post Your Comment

Next Questions
SET Data Types
Difference between varchar and char
Difference between Tinyint and smallint
Difference between enum and set
Difference between signed and unsigned
Operators
Arithmetic Operators
Comparison Operators
Logical Operators
What is key
What is super key
What is candidate key
What is primary key
What is unique key
What is foreign key
What is join
What is cross join
What is natural join
What is outer join
What is self join
What is aggregate function
COUNT(*) aggregate function
AVG() aggregate function
MIN() aggregate function
MAX() aggregate function

Copyright ©2022 coderraj.com. All Rights Reserved.