MySQL version property

Official Content
This documentation is valid for:
Sets the MySQL version range for which the code is generated.

Values

4.x to 5.0.2 The MySQL version installed in the Server is a version between 4.x and 5.0.2.
5.0.3 to 5.7.6 The MySQL version installed in the Server is a version between 5.0.3 and 5.7.6.
5.7.7 to 5.7.23 The MySQL version installed in the Server is from 5.7.7 to 5.7.23.
8.x or higher The MySQL version installed in the Server is 8.x or higher.

Description

This property is used, for example, to determine the syntax for OUTER JOINs and for table creation/reorganization (i.e. syntax of CREATE TABLE, CREATE INDEX, etc.).

Note: Although the property can be set to MySQL version 8.x, there are still some known issues related to Geography data types and time zones among others that are under review. So the MySQL 8.x version is still not fully supported (as of November 2018).

Run-time/Design-time

This property applies only at design-time.

How to apply changes

To apply changes made by this property, do a Re-Build All.

Scope

Available at the Data Store.
Data Store: MYSQL

See Also