2011

Table Of Contents
Working with MySQL Data
AutoCAD Map 3D supports MySQL 5.0.27 In AutoCAD Map 3D, you can
create, edit, and delete a MySQL data store (page 2059) or schema (page 2073). You
can also use MySQL to access databases 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.
NOTE If you cannot connect to your MySQL data source, you may see an error
message: "Specified credentials are not valid or the provider is unable to establish
a connection." To resolve the issue, copy the libmySQL.dll file into the AutoCAD
Map 3D\FDO\bin folder and try again.
NOTE This functionality affects geospatial feature data only. For information about
linking records in an external database to objects in a drawing, see
Overview of
Linking Database Records to Objects
(page 522).
What MySQL Schemas Support
A MySQL schema can support the following:
Inheritance
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
Working with MySQL Data | 567