MySql

About

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

Catalog vs Database vs Schema

In MySQL 1) :

  • 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

Version

MySql is tested against version 5.7.

Howto

To follow the Howto, you need to start a MySql container database. The steps by steps are available on this page: MySQL - How-to Connection

Note

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`)
Task Runner