Site icon TestingDocs.com

MySQL SET Datatype

Overview

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/

For more information on MySQL Database:

https://www.mysql.com/

Exit mobile version