Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Difference between ENUM and SET in SQL.?

Programming SQL SQL Server 2000 2008 Database
user-image
Question added by Abdul Khader Shaik , Cyber Crime Lawyer , Grofers
Date Posted: 2018/01/03
Upvote (0) Views (2) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Wojciech Kakol
by Wojciech Kakol , Senior Business Intelligence Developer , VOLVO IT

An ENUM value must be one of those listed in the column definition. The value cannot be the error value (0 or '').

A SET value must be the empty string or a value consisting only of the values listed in the column definition separated by commas.

More here:

https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html

Write Your Answer
More Questions Like This