Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
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 Project | Settings | Database Datatypes
Add the ENUM and SET data types for MySQL
Step |
Action |
See also |
|---|---|---|
1 |
The Database Datatypes dialog displays.
|
|
2 |
In the Product Name field select MySql.
|
|
3 |
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:
('one','two','three')
If one value is the default, use the format:
('one','two','three') default 'three'
The material ("material" includes all pages, documents and on-line graphics) on this web site is protected by copyright law. (C) 1998-2015 Sparx Systems Pty Ltd.
