AutoCAD Map 3D supports MySQL
5.0.27 In AutoCAD Map 3D, you can create, edit, and delete a MySQL data store or schema.
You can also access existing databases in MySQL that were created
by other applications. AutoCAD Map 3D supports native MySQL geometry,
indexing, two-dimensional geometry (compatible with the OGC Simple
Feature specification), and spatial query operations, but not transactions.
Auto-generated properties are automatically incremented (auto-incremented).
MySQL uses a revision number for optimistic concurrency.
you cannot connect to your MySQL data source and you receive the error
message, "Specified credentials are not valid or the provider is
unable to establish a connection," copy the libmySQL.dll file into the AutoCAD Map 3D\FDO\bin folder and try
What MySQL Schemas Support
A MySQL schema can support
- Multiple schemas
- Object properties (with limitations)
- Association properties (with limitations)
- Schema overrides
- Auto ID generation
- Default values
- Null value constraints
- Unique value constraints
- Composite unique value constraints
- Spatial contexts
- The following geometry types:
- Polygons: polygon, multi-polygon, curve
polygon, multi-curve polygon, circular arc segment
- Points: point, multi-point
- Rings: ring, linear ring
- Line strings: line string, line string
segment, multi-line string, curve string, multi-curve string
Restrictions of MySQL Schemas
When you create a MySQL
schema, the following restrictions apply:
- A feature class must
define or inherit at least one identity property.
- Inclusive value range constraints are
- Identity properties cannot be nullable.
- Read-only identity properties must be
- A feature class can have multiple geometric
properties. Although it is not mandatory, having a main geometry
as an attribute of the feature class can help you to identify which
geometry property to use as the default for queries and rendering.
Both HasMeasure and HasElevation are supported.
- The maximum length of a string is 65,535
- For decimal properties, the precision
must be between 1 and 65, inclusive, and the scale must be between
0 and 30, inclusive.