SQL

INSERT INTO animals (name) VALUES
    ('dog'),('cat'),('penguin'),
    ('lax'),('whale'),('ostrich');

CREATE DATABASE foo CHARACTER SET utf8mb4;

CREATE TABLE animals (
     id MEDIUMINT NOT NULL AUTO_INCREMENT,
     name CHAR(30) NOT NULL,
     PRIMARY KEY (id)
);

-- AUTO_INCREMENT値のリセット
ALTER TABLE foo AUTO_INCREMENT = 1

-- RENAME TABLE相当
ALTER TABLE A RENAME [TO|AS] B

RENAME TABLE A TO B [, C TO D [...]]

LEFT(str, len)
RIGHT(str, len)

DO SLEEP(5);

SHOW BINARY LOGS
SHOW MASTER LOGS

SHOW BINLOG EVENTS
   [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]

-- 現在のユーザの権限を表示
SHOW GRANTS;