How to Install MySQL in PostgreSQL

Why How to Install MySQL in PostgreSQL is important

-- List total spent by each customer after fresh install
SELECT c.name, SUM(o.total_amount) AS lifetime_value
FROM Customers c
JOIN Orders o ON o.customer_id = c.id
GROUP BY c.id, c.name
ORDER BY lifetime_value DESC;

# Ubuntu / Debian
sudo apt update && sudo apt install mysql-server

# RHEL / CentOS / Amazon Linux
sudo yum install https://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm
sudo yum install mysql-community-server

# macOS (Homebrew)
brew update && brew install mysql

# Windows (Chocolatey)
choco install mysql

# Optional post-install: create ecommerce schema
after connecting with `mysql -u root -p`:

CREATE DATABASE shop;
USE shop;

CREATE TABLE Customers (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(100),
  email VARCHAR(150),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE Products (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(120),
  price DECIMAL(10,2),
  stock INT
);
CREATE TABLE Orders (
  id INT PRIMARY KEY AUTO_INCREMENT,
  customer_id INT,
  order_date DATE,
  total_amount DECIMAL(10,2),
  FOREIGN KEY (customer_id) REFERENCES Customers(id)
);
CREATE TABLE OrderItems (
  id INT PRIMARY KEY AUTO_INCREMENT,
  order_id INT,
  product_id INT,
  quantity INT,
  FOREIGN KEY (order_id) REFERENCES Orders(id),
  FOREIGN KEY (product_id) REFERENCES Products(id)
);