Prev | Next |
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
Ribbon |
Configure > Reference Data > Settings > Database Datatypes |
Add the ENUM and SET data types for MySQL
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'
Step |
Action |
See also |
---|---|---|
1 |
The 'Database Datatypes' dialog displays. |
Database Datatypes |
2 |
In the 'Product Name' field select 'MySQL'. |
|
3 |
Add the data types ENUM and SET. |