MySQL Data Types

MySQL supports the ENUM and SET data types, which must be added to your Enterprise Architect model before you can use them as the types for columns.

Access:    Settings | Database Datatypes

How To:

To add the ENUM and SET data types for MySQL, follow the steps below:



See Also


Select the Database Datatypes menu option

The Database Datatypes dialog displays



In the Product Name field select MySQL



Add the data types ENUM and SET


When using these data types later in a Column's Initial field, type the values as a comma-separated list, in the format:


If one value is the default, use the format:

('one','two','three') default 'three'