purposes of using ENUM and SET data types

Question

Kindly explain ENUM and SET data types with it’s examples and the purposes in MYSQL Database.

Harsh Shah · Answer

Hi, please refere bellow link : http://www.thecreativedev.com/avoid-to-use-enum-and-set-type-in-mysql/ http://download.nust.na/pub6/mysql/tech-resources/articles/mysql-set-datatype.html

Dinesh Gabhane · Answer

Please refer below documentation and Article https://dev.mysql.com/doc/refman/8.0/en/constraint-enum.html http://www.mysqltutorial.org/mysql-enum/ https://codeburst.io/mysql-data-type-dive-enum-with-examples-b5fcb3e5da12

Rajanikant Hawaldar · Answer

Hi Dipa Mehta, I work on WPF,WCF,Oracle currently let me explain how enums are useful realtime application. In my application we added Save, Modify, Delete, View, Remove, RemoveAll buttons, i have one HelperClass in which i have added few enums, example: ButtonAction etc. When click on button commandparameter passes this particular enum for example if click on Save button 'Save' from ButtonAction enum will be pass as parameter through WPF window application -> WCF->ADO.NET->MYSQL to do particular action in db side.

Nirmal Dayal · Answer

Hi Dipa, Below url help for requirement. https://www.tutorialsteacher.com/csharp/csharp-enum

purposes of using ENUM and SET data types

Answers (4)