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