2011

Table Of Contents

Bringing In Features from MySQL

When you view and edit features from a MySQL data source, you can do the

following:

■ Select the feature classes to include in your map.

■ Set conditions to limit the features in your map.

■ Style, theme, and edit the features.

■ Automatically update the data source with any edits you make.

Your edits are immediately visible to anyone else using the data source.

■ Use a data store set up for AutoCAD Map 3D or in other applications. If

your data source schema is not set up to work with AutoCAD Map 3D, for

example, AutoCAD Map 3D creates a custom mapping so you can use the

data in your map.

■ View and edit the schema definition.

■ Create a MySQL data source.

■ Move data from other geospatial sources (for example, SHP data) into

MySQL, to take advantage of better data sharing.

For AutoCAD Map 3D 2011, the recommended version of MySQL is 5.0.27.

In the 2008 release of AutoCAD Map 3D, a new column called geometrytype

was added to the table named F_AttributeDefinition. To use AutoCAD Map

3D 2011 to access FDO data stores that were created in AutoCAD Map 3D

2007 and earlier, you must first connect to the data store containing this table

and run a SQL script. Instructions for this are on the Procedure tab of this

topic.

NOTE The MySQL architecture supports different storage engines, each with

varying characteristics and capabilities. The API has custom commands for gathering

information, transmitting exceptions, getting lists of accessible data stores, and

creating connection objects. There is support for spatial data types and spatial

query operations. For more information, refer to the FDO API Reference and the

FDO Provider for MYSQL API Reference.