MySQL

Version:
Current
Last modified: October 19, 2020
Connection Type

ODBC (32- and 64-bit)

Type of Support

Read & Write, In-Database

Validated On

Database version 5.1
Database version 5.6, 5.7 (Spatial support)
ODBC client version 5.01.04.00, 5.01.12.00
ODBC client version 5.02.06.00, ANSI and Unicode® encoding (Spatial support)
ODBC Client Version 8.0.19

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 Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.