dbSetup.sql

CREATE TABLE
  IF NOT EXISTS accounts (
    id VARCHAR(255) NOT NULL PRIMARY KEY COMMENT 'primary key',
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'Time Created',
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last Update',
    name VARCHAR(255) COMMENT 'User Name',
    email VARCHAR(255) UNIQUE COMMENT 'User Email',
    picture VARCHAR(255) COMMENT 'User Picture'
  ) DEFAULT charset utf8mb4 COMMENT '';

CREATE TABLE
  cats (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    color VARCHAR(255) NOT NULL,
    breed ENUM (
      'house',
      'bob',
      'barn',
      'sphinx',
      'cougar',
      'lion',
      'mystery',
      'tiger'
    ) NOT NULL,
    age TINYINT UNSIGNED NOT NULL,
    is_single BOOLEAN NOT NULL
  );

ALTER TABLE cats MODIFY COLUMN breed ENUM (
  'house',
  'bob',
  'barn',
  'sphinx',
  'cougar',
  'lion',
  'mystery',
  'tiger'
);

DROP TABLE cats;

INSERT INTO
  cats (name, age, breed, color, is_single)
VALUES
  ('georgie', 8, 'house', 'gray tabby', FALSE);

INSERT INTO
  cats (name, age, breed, color, is_single)
VALUES
  ('dr. strange', 40, 'mystery', 'giraffe', TRUE),
  ('abomination', 255, 'lion', 'tan', FALSE);

SELECT
  name,
  age
FROM
  cats;

SELECT
  *
FROM
  cats;

SELECT
  *
FROM
  cats
WHERE
  age > 20;

SELECT
  *
FROM
  cats
WHERE
  age BETWEEN 9 AND 254;

SELECT
  *
FROM
  cats
WHERE
  id = 2;

SELECT
  *
FROM
  cats
WHERE
  is_single = TRUE;

DELETE FROM cats
WHERE
  id = 5;

UPDATE cats
SET
  name = "Dr. Strange"
WHERE
  id = 100;

SELECT
  COALESCE(
    GROUP_CONCAT (
      name
      ORDER BY
        name SEPARATOR ''
    ),
    ''
  ) AS name
FROM
  cats;