docker_mysql_command.sh

docker run \
    -e MYSQL_ROOT_PASSWORD=password \
    -e MYSQL_USER=test \
    -e MYSQL_PASSWORD=password \
    -e MYSQL_DATABASE=test \
    -e TZ=Asia/Tokyo \
    -p 3306:3306 \
    --name mysql_db \
    -d mysql:5.7

init_database.sql

# 9章のSQL

CREATE DATABASE mydbexample DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE mydbexample;

CREATE TABLE zaiko
(idzai INT NOT NULL AUTO_INCREMENT,
 product VARCHAR(50) NOT NULL,
 stock INT NOT NULL DEFAULT 0,
 PRIMARY KEY (idzai));

CREATE TABLE shukko (
 idko INT NOT NULL,
 taiou INT NOT NULL,
 outnum INT NOT NULL,
 outdate DATETIME NOT NULL,
 PRIMARY KEY (idko),
 INDEX (taiou)
 );
 ALTER TABLE shukko ADD FOREIGN KEY (taiou) REFERENCES zaiko(idzai) ON DELETE RESTRICT ON UPDATE RESTRICT;

how to use mysql client on docker

$ docker exec -it mysql_db bash
$ mysql -u root -p

mysql> use test;