turbohaa.blogg.se - Mysql workbench portable mega

Let us consider simple example for the same: – If we check the list of all users the columns defined in the user table are mostly defined as a ENUM data type. Let us see where the ENUM usually defined in the MySQL.

It has queries readable which makes it as readable queries and output.

) which represent the string values because of which it has compact data storage.

MySQL ENUM uses numeric indexes (1, 2, 3.

Here the values for the “column_name1” and “column_name2” are one among the list specified.

Let us see the syntax of how we create the column of ENUM datatype: –Ĭolumn_name1 ENUM(value1, value2.),/ * - ENUM Data type column - * /Ĭolumn_name2 ENUM(value1, value2.),/ * - ENUM Data type column - * / Hadoop, Data Science, Statistics & others