MySql

About

MySql is a relational database system that is supported as source and target.

Howto

To follow the Howto, you need to start a MySql container database.

The steps by steps are available on this page: How to start and use the HowTo MySQL database in Tabulify

Creation

See How to create an MySQL connection?

Support

Catalog vs Database vs Schema

In MySQL ¹⁾ :

• SQL Catalog are called database
• SQL Schema are not supported

Because Tabulify is data source agnostic, a MySql Catalog is known as a schema (ie the first parent).

To known about the historic of it, check this article

Upsert

MySql does not support the statement insert on conflict.

We have implemented for the upsert operation the on duplicate key update statement.

Example:

insert into `howto`.`d_category` (`cat_id`, `cat_desc`, `load_timestamp`)
values (1, 'desc', '2020-11-17 13:20:38.5')
on duplicate key update `load_timestamp` = values(`load_timestamp`)

Data Type

See MySQL Data Type Support

Version

MySql is tested against version 5.7.