MySQL SET Datatype
MySQL SET Datatype
In this tutorial, we will learn about MySQL SET Datatype. A set an unordered list or collection of distinct things considered as a whole. Like the ENUM data type, the definition of a SET data type comprises a list of pre- defined values.
Syntax
The general syntax for assigning a column to the SET data type is as follows:
SET(‘Value1’, ‘Value2′,’Value3’,…….)
The difference with the ENUM data type is that a value for that particular SET data type can be a list of any of these value. A SET column can have a maximum of 64 members. SET values are represented internally as integers.
Example
—
MySQL Tutorials
MySQL Tutorials on this website:
https://www.testingdocs.com/mysql-tutorials-for-beginners/
