Script can be used to create a test mySQL database to be queried using a custom coded workflow action

operations-hub-workshop.sql

/* create database "customers" */
CREATE DATABASE customers;

/* use the database "customers" */
USE customers;

/*
  Create table in the "customers" database called "customer_info".
  This will have columns to hold data relating to our customers namely
  their name and email address. CustomerID is the primary key and is an auto-generaged
  unique number.
*/
CREATE TABLE customer_info(
	CustomerID int AUTO_INCREMENT,
    FirstName varchar(255),
    LastName varchar(255),
    EmailAddress varchar(255),
    PRIMARY KEY (CustomerID)
);

/*
 Retrieve all of the rows within the "customer_info" table.
 Initially this should return nothing but over time it will populate when you
 run your custom coded worklfow actions in HubSpot
*/
SELECT * FROM customer_info;