versipellis

Basic Setup of MariaDB for Versipellis

1. Start a MariaDB Docker container

   docker run --name my-mariadb -p 3306:3306 -e MARIADB_RANDOM_ROOT_PASSWORD=yes \
          -e MARIADB_DATABASE=versi_db -e MARIADB_USER=larry -e MARIADB_PASSWORD=woof \
          --detach mariadb:latest
   

   (Alternative: download and install MariaDB)

2. Connect to MariaDB

   docker exec -it my-mariadb mariadb --user=larry --password=woof --database=versi_db
   

3. Create a new table ¹

   CREATE TABLE IF NOT EXISTS input_data (
       id        INT         AUTO_INCREMENT PRIMARY KEY,
       name      VARCHAR(50) NOT NULL UNIQUE,
       last_seen TIMESTAMP   DEFAULT (NOW() - INTERVAL FLOOR(RAND() * 31536000) SECOND),
       rand_key  UUID        DEFAULT UUID_v4()
   );
   

   Optional check:

   DESCRIBE input_data;
   

4. Insert rows into the table

   INSERT INTO input_data (name) VALUES ('Alice'), ('Bob'), ('Carol'), ('Dave'), ('Eve');
   

   Optional check:

   SELECT * FROM input_data;
   

5. Exit

   \q
   

1. The UUID_v4() function is available since MariaDB 11.7 ↩

This site is open source. Improve this page.