MySQL

To create a PDM with support for features specific to the MySQL DBMS family, select the appropriate version in the DBMS field of the New Model dialog. To view these extensions to the PowerDesigner metamodel in the Resource Editor, select Database > Edit Current DBMS and expand the Profile node.

Note:

The DBMSs for MySQL v3.22 and 3.23 are deprecated. In v4.0 the attributes listed below are available on the Extended Attributes tab.

Note that when developing for MySQL and using double quotes as a delimiter, it is necessary to set the sql_mode to ANSI_QUOTES:

SET sql_mode='ANSI_QUOTES'

The following sections list the extensions provided for MySQL.

Columns

The following extended attributes are available on the MySQL tab:

Name	Description
Retrieve with leading zeros	When displayed, the default padding of spaces is replaced with zeros. For example, for a column declared as INT(5) ZEROFILL, a value of 4 is retrieved as 00004. If you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column. Scripting name: ZeroFill
Unsigned	Indicates negative values are not allowed for the column. Scripting name: Unsigned
National	A way to indicate that a CHAR column should use UTF8 character set. Scripting name: National
Character set	Set of symbols and encodings. Scripting name: CharSet
Collation	Set of rules for comparing characters in a character set. Scripting name: Collate

Indexes

The following extended attributes are available on the MySQL tab:

Name	Description
Full text index	Indicates that the index is a full text index. Scripting name: FullText

Name

Description

Full text index

Indicates that the index is a full text index.

Scripting name: FullText

Keys

The following extended attributes are available on the MySQL tab:

Name	Description
Unique key	When set to True, indicates that the key is unique. False implies that the key allows duplicate values. Scripting name: ExtUnique

Name

Description

Unique key

When set to True, indicates that the key is unique. False implies that the key allows duplicate values.

Scripting name: ExtUnique

Models

The following extended attributes are available on the MySQL tab:

Name	Description
Database type	Indicates the type of the database, as specified in the extended attribute type DatabaseType. Scripting name: DatabaseType

Name

Description

Database type

Indicates the type of the database, as specified in the extended attribute type DatabaseType.

Scripting name: DatabaseType

References

The following extended attributes are available on the MySQL tab:

Name	Description
Reference match type	Indicates the reference match type, as specified in the extended attribute type ReferenceMatchType. Scripting name: ReferenceMatch

Name

Description

Reference match type

Indicates the reference match type, as specified in the extended attribute type ReferenceMatchType.

Scripting name: ReferenceMatch

Tables

The following extended attributes are available on the MySQL tab:

Name	Description
Temporary table	[v5.0 and higher] Used to create a temporary table. A temporary table is visible only to the current connection, and is dropped automatically when the connection is closed. Scripting name: Temporary

Name

Description

Temporary table

[v5.0 and higher] Used to create a temporary table. A temporary table is visible only to the current connection, and is dropped automatically when the connection is closed.

Scripting name: Temporary