Online Documentation for Data Generator for MySQL

ENUM and SET field parameters

An ENUM or a SET field in MySQL is a string object with a value which is selected from a list of defined values. Values for this field can be generated randomly or they can be taken from a fixed list of values or SQL query.


The Generation properties panel allows you to define preferences for generating values for ENUM and SET field types.


ENUM field parameters



Select Data generation mode as follows:


RadioButton Generate random data

There are no additional parameters for this field type.


ENUM field parameters - Mode - Random data



RadioButton Get data from List / SQL query

This panel allows you to define the list of values to generate list data from. You can enter these values directly into the editor by selecting the List of Values option.

To add a single value, use the btnListAddValue Add Value button.

To load a list of values from an existing external file, use the btnListLoadFromFile Load from file button.

To save the list to an external file, use the btnListSaveToFile Save to file button.

To remove a single value, use the btnListDeleteValue Delete Value button.

To remove all items from the list, use the btnListClear Clear button.


You can also specify whether the values are to be taken in random order or in the order they have been inputted.


Alternatively, you can set the SQL Query option and input an SQL query into the editor, and the resulting dataset will be used as the list for data generation.


ENUM field parameters - Mode - List or query