vitess.io/vitess@v0.16.2/examples/compose/external_db/mysql/commerce.sql (about)

     1  CREATE DATABASE IF NOT EXISTS commerce;
     2  USE commerce;
     3  DROP TABLE IF EXISTS users;
     4  CREATE TABLE users (
     5     device_id BIGINT,
     6     first_name VARCHAR(50),
     7     last_name VARCHAR(50),
     8     telephone BIGINT,
     9     gender VARCHAR(16),
    10     reference_id INT,
    11     confidence INT,
    12     coverage INT,
    13     refstart DATETIME,
    14     refstop DATETIME,
    15     qrystart DATETIME,
    16     qrystop DATETIME);
    17  
    18  LOAD DATA LOCAL INFILE '/docker-entrypoint-initdb.d/dataset.csv' INTO TABLE users FIELDS TERMINATED BY ',';
    19  
    20  ALTER TABLE users ADD id INT NOT NULL AUTO_INCREMENT PRIMARY KEY;