robrich

create database maps;
use maps;

create table countries (
  boundary geography,
  name_short varchar(3),
  name varchar(50),
  name_long varchar(50),
  abbrev varchar(10),
  postal varchar(4),

robrich

-- Create database
create database if not exists acme;
use acme;

-- Create table
create rowstore table `record` (
  `name` varchar(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  SHARD KEY () 

robrich

create database db1;
use db1;

create table t(a int not null, shard(a), sort key());

insert t values(1);

delimiter //
/* Fill table t with n or more rows, doubling the size until
 the goal is reached. */

robrich

-- TIME SERIES
-- ===========

-- setup schema
CREATE DATABASE temp_history;

USE temp_history;

CREATE TABLE temperatures (
  location VARCHAR(200) NOT NULL,

robrich

-- FULL TEXT SEARCH
-- ================

-- setup schema
CREATE DATABASE library;

USE library;

CREATE TABLE books (
  title VARCHAR(200) not null,

robrich

license: YOUR_LICENSE_KEY
memsql_server_version: 7.1.8
package_type: rpm
hosts:
- hostname: 127.0.0.1
  localhost: true
  nodes:
  - register: false
    role: Master
    config:

robrich

-- 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));

robrich

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
);

robrich

-- 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));

robrich

create database acme;

use acme;

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