MySql struct encapsulates the MySql server database access functionality by wrapping Sqlx package with top level methods Charset = utf8, utf8mb4 (< Default) Collation = utf8mb4_general_ci (< Default), utf8_general_ci ...Timeout = must be decimal number with unit suffix (ms, s, m, h), such as "30s", "0.5m", "1m30s" MaxOpenConns = maximum open and idle connections for the connection pool, default is 0, which is unlimited (db *sqlx.DB internally is a connection pool object) MaxIdleConns = maximum number of idle connections to keep in the connection pool, default is 0 which is unlimited, this number should be equal or less than MaxOpenConns MaxConnIdleTime = maximum duration that an idle connection be kept in the connection pool, default is 0 which has no time limit, suggest 5 - 10 minutes if set.

MySqlResult defines sql action query result info [ Notes ] 1.

MySqlTransaction represents an instance of the sqlx.Tx.

QueryBuilder struct to help build sql queries (use named parameters instead of ordinal).