Create Database and Tables

Connect to your SingleStore deployment and run the following SQL commands to create a database named trades and two associated tables.

Note

The SQL Editor only runs the queries that you select, so ensure you have them all selected before selecting Run.

SQL

DROP DATABASE IF EXISTS trades;
CREATE DATABASE trades;
USE trades;

CREATE TABLE company (
  symbol char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  name varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  last_sale varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  market_cap varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  IPO_year float DEFAULT NULL,
  sector varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  industry varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  summary_quote varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  extra varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  SORT KEY __UNORDERED ()
  , SHARD KEY () 
);

CREATE TABLE trade (
  id bigint(20) NOT NULL,
  stock_symbol char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  shares decimal(18,4) NOT NULL,
  share_price decimal(18,4) NOT NULL,
  trade_time datetime(6) NOT NULL,
  SORT KEY stock_symbol (stock_symbol),
  SHARD KEY __SHARDKEY (stock_symbol)
);

Create Database and Tables

Was this article helpful?

Was this article helpful?