# go-mysqldiff

**Repository Path**: myzero1/go-mysqldiff

## Basic Information

- **Project Name**: go-mysqldiff
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-09-15
- **Last Updated**: 2020-12-20

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

mysqldiff -get diff between src and dst [badge]
-----

mysqldiff shows difference between database and sql file, sql files and databases.

[original mysqldiff](https://github.com/onishi/mysqldiff) is created by [@onishi](https://twitter.com/onishi).

mysqldiff get two <Schema> args , one is "source" and the other is "destination".
Schmea has two types:

* database
* sql.file

## Usage

```
% mysqldiff "-hlocalhost current" ./sql/newschema.sql
ALTER TABLE sushi ADD COLUMN `freshness` INT NOT NULL AFTER `price`;
CREATE TABLE yakizakana (
  id   INT UNSIGNED ...,
  name VARCHAR(255),
  ...
)
```

### Source Combination

* database - database
  * `mysqldiff "-hproduction sample" "-hlocalhost sample"`
* database - sql file
  * `mysqldiff "-hproduction sample" ./new.sql`
* sql file - sql file
  * `mysqldiff ./old.sql ./new.sql`

## Schema type detection

mysqldiff detects one from two shcema type by existance of given file.

## TODO

* write tests.
* use goroutin/channel to read schemas.