MySql

MySql#

MySql provider is bundled with Querona and no additional installation or configuration is required.

Excluded functions#

The following MySql functions are excluded by Querona’s SQL optimization engine:

Function name

Exclusion reason

SOUNDEX

SOUNDEX implementation in MySql is unreliable.

IDENTITY / auto-increment columns#

Querona renders a T-SQL IDENTITY column declaration in MySQL’s native AUTO_INCREMENT form when the declaration is exactly achievable, and rejects the CREATE TABLE with a capability error otherwise:

  • Any seed is accepted when increment is 1. MySQL has no per-table increment step, so any other increment is rejected.

  • The column is declared AUTO_INCREMENT; when seed is not 1, Querona also adds an AUTO_INCREMENT = seed table option so the counter starts at the declared value.

  • The identity column must also be indexed (PRIMARY KEY or UNIQUE) — MySQL requires an AUTO_INCREMENT column to be a key. A non-indexed identity column is rejected.

CREATE TABLE dbo.Product (
    Id    int          IDENTITY(1000, 1) PRIMARY KEY,
    Code  nvarchar(20) NOT NULL
);

AUTO_INCREMENT columns on an existing MySQL source table are imported during schema analysis: Querona sets is_identity on sys.columns for them, carrying the flag only — MySQL’s catalog does not expose a seed or increment to import.

See also#