mysql-ci

README

mysql-ci

This tools is a simple cli of mysql for CI.

How to install

# You need to add "$(go env GOPATH)/bin" to "PATH"
go install github.com/KamikazeZirou/mysql-ci@v0.1.0

Usage

Write a file named 'init.sql' like below.

CREATE DATABASE IF NOT EXISTS testdb;
USE testdb;

CREATE TABLE `foobar` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    PRIMARY KEY(`id`)
);

Then, run a command like below.

mysql-ci -h 127.0.0.1 -p 3306 -pass password -f 'init.sql'

You can directly specify a query by using option '-q' instead of '-f'.