create_test_db.sql

CREATE DATABASE IF NOT EXISTS test_db;

CREATE TABLE IF NOT EXISTS test_db.users (
  id INT AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  age INT NOT NULL,
  sex TINYINT NOT NULL DEFAULT 0,
  PRIMARY KEY (id)
);

INSERT INTO test_db.users (name, age, sex)
  VALUES ('taro', 18, 1),
         ('jiro', 17, 1),
         ('hanako', 21, 2),
         ('himawari', 20, 2);