MySQL

Version:
2021.2
Last modified: July 12, 2021
Connection Type

ODBC (32- and 64-bit)

Type of Support

Read & Write, In-Database

Validated On

Database Version: 8.0.25
ODBC Client Version: 1.1.2.1002

Alteryx Tools Used to Connect

For Standard Workflow Processing

Link
Input Data Tool Icon

Input Data Tool

Link
Output Data Tool Icon

Output Data Tool

For In-Database Workflow Processing

Link
Blue icon with database being plugged in.

Connect In-DB Tool

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

Data Stream In Tool

Limitations

Database Version 5.1
  • Maximum Columns In Table: 4096
  • Maximum Column Name Length: 64 Characters
  • Maximum Row Size: 65535 Bytes (does not include LOB size)
ODBC Version 5.01.04.00 (32- and 64-bit)
  • Fixed Numeric is transported as a SQL_C_CHAR; SQL_NUMERIC not supported.
  • Known bug with BIT datatypes (MySQL Bug#37118): Returns false no matter what you do.
OLEDB

MySQL does not have a native OLEDB provider.

Spatial
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.