VeryFatBoy

-- Step_1: setup
Create database testDB;
use testDB;
Create table t( a int, b varchar(70));
insert into t values (1, now(6));
insert into t select a+(select max(a) from t), now(6) from t;
select count(*) from t; 

-- Step_3: updates on primary
insert into t values (-1, now(6));

VeryFatBoy

CREATE DATABASE IF NOT EXISTS hellomemsql;

USE hellomemsql;

CREATE TABLE IF NOT EXISTS messages (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  content varchar(300) NOT NULL,
  createdate TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP
);

VeryFatBoy

-- Step_1: setup
Create database testDB;
use testDB;
Create table t( a int, b varchar(70));
insert into t values (1, now(6));
insert into t select a+(select max(a) from t), now(6) from t;
select count(*) from t; -- 262144  

-- Step_3: updates on primary
insert into t values (-1, now(6));

VeryFatBoy

create database acme;

use acme;

create table customer (
  id int,
  name varchar(200),
  properties json not null,
  key (id) using clustered columnstore
);

VeryFatBoy

create database 'tpc_h';
use 'tpc_h';

CREATE TABLE IF NOT EXISTS `lineitem` (
`l_orderkey` bigint(11) NOT NULL,
`l_partkey` int(11) NOT NULL,
`l_suppkey` int(11) NOT NULL,
`l_linenumber` int(11) NOT NULL,
`l_quantity` decimal(15,2) NOT NULL,
`l_extendedprice` decimal(15,2) NOT NULL,

VeryFatBoy

-- create a database with 2 master partitions
create database thedb partitions 2;

-- create sample data
use thedb;
create table data (msg varchar(200));
insert into data (msg) values ('the data');

-- notice how we're not using the database efficiently
show partitions;

VeryFatBoy

-- create a database
create database cosmeticshop;

-- create a table
use cosmeticshop;
create table cosmeticshopfunnel
(
    event_time TIMESTAMP,
    event_type CHAR(18),
    product_id CHAR(10),

VeryFatBoy

VeryFatBoy

VeryFatBoy

apiVersion: apps/v1
kind: Deployment
metadata:
  name: memsql-operator-envvar
  namespace: memsql
spec:
  replicas: 1
  selector:
    matchLabels:
      name: memsql-operator-envvar