Enumerations in Computational Languages

Let’s learn about enumeration in various computational languages such as SQL, XML, and JS.

Enumerations in SQL

Unfortunately, standard SQL does not support enumerations. Some DBMS, such as MySQL and Postgres, provide their own extensions of SQL column definitions in the CREATE TABLE statement that define enumeration-valued columns.

A MySQL enumeration is specified as a list of enumeration labels with the keyword ENUM within a column definition, as shown below:

Get hands-on with 1200+ tech skills courses.