MariaDB

Brief

• open source (GNU GPL)
• MySQL compatible
• supports multiple storage engines : InnoDB (Default), MyISAM, ARIA

SQL

• var for identifiers (db name, ...)
• 'var' for string literals (password,...)

Commands

database operations

• CREATE DATABASE name;
• USE name;

table operations

• CREATE TABLE name (column1 datatype, ...);
• DROP TABLE name;
• ALTER TABLE name ADD column datatype;
• ALTER TABLE name DROP column;

data manipulation

• INSERT INTO table (column1, ...) VALUES (value1, ...);
• UPDATE table SET column = value WHERE condition;
• DELETE FROM table WHERE condition;

data query

• SELECT column FROM table WHERE condition;
• GROUP BY
• ORDER BY

joins

• ... INNER JOIN table2 on table1.column = table2.column;
• LEFT JOIN

aggregation

• COUNT
• AVG
• SUM
• MIN
• MAX

indexing

• CREATE INDEX name ON table (column);

views

• CREATE VIEW name AS SELECT columns FROM table WHERE condition;

transaction

• BEGIN;
• COMMIT;
• ROLLBACK;

cf

• https://www.datacamp.com/cheat-sheet/sql-basics-cheat-sheet

mysql CLI

mysql -e : execute SQL commands in the command line

Testing

• status docker ps
• infos docker inspect mariadb : IP address, ...
• logs docker logs mariadb
• active processes docker top mariadb
• resources docker stats mariadb
• test connectivity from other containers mysql -h 127.0.0.1 -u root -p

Inside container

docker exec -it mariadb mysql -u root -p

Sources

https://www.ubuntumint.com/install-mariadb-alpine-linux/ https://wiki.alpinelinux.org/wiki/MySQL