Skip to main content

[en] MySQL

[en] Connection Type

[en] ODBC (64-bit)

[en] Type of Support

[en] Read & Write, In-Database

[en] Validated On

[en] Database Version: 8.0.25

[en] ODBC Client Version: 1.1.2.1002

[en] Alteryx Tools Used to Connect

[en] For Standard Workflow Processing

[en] Input Data Tool

Input Data Tool Icon

[en] Link

[en] Output Data Tool

Output Data Tool Icon

[en] Link

[en] For In-Database Workflow Processing

[en] Connect In-DB Tool

Blue icon with database being plugged in.

[en] Link

[en] Data Stream In Tool

Blue icon with a stream-like object flowing into a database.

[en] Link

[en] Limitations

[en] Database Version 5.1

  • [en] Maximum Columns In Table: 4096

  • [en] Maximum Column Name Length: 64 Characters

  • [en] Maximum Row Size: 65535 Bytes (does not include LOB size)

[en] ODBC Version 5.01.04.00 (32- and 64-bit)

  • [en] Fixed Numeric is transported as a SQL_C_CHAR; SQL_NUMERIC not supported.

  • [en] Known bug with BIT datatypes (MySQL Bug#37118): Returns false no matter what you do.

[en] OLEDB

[en] MySQL does not have a native OLEDB provider.

[en] Spatial

  • [en] Projections are not supported for writing spatial data.

  • [en] The Spatial Match tool only supports the "Intersects" calculation type.

  • [en] The Find Nearest tool is not supported.

: