jacques / mysql-inspector Goto Github PK
View Code? Open in Web Editor NEWThis project forked from rcarver/mysql-inspector
Tools for identifying changes to a MySQL schema
This project forked from rcarver/mysql-inspector
Tools for identifying changes to a MySQL schema
mysql-inspector is a simple tool for diffing and searching mysql dumps. Why do I need that? It helps you migrate your schema from one version to another. Ok, how? Say you have a project called zippers. Your development database is called zippers_development. You're working on a branch called smoother, based on master, which adds a new column metal_grade. Start by storing the new state of your database. % mysql-inspector --target --write zippers_development This command says "store the state of the zippers_development database as my target version". Now, go back to your master branch and load its database into zippers_development, then dump the contents. % mysql-inspector --current --write zippers_development Now, in order to write database migrations for master to smoother let's see what changes occurred. % mysql-inspector --diff [[ show sample output ]] Here we see that our target version contains one column that the current version does not. It's easy to write an alter statement, in fact most of the information is right here. mysql% alter table zippers add column metal_grade int(11) NOT NULL DEFAULT '0'; Now we can compare the two again. This time we need to add the --force argument to say that it's ok to overwrite the previous dump. We'll also go ahead and run the diff. % mysql-inspector --current --write zippers_development --force --diff No differences! That was pretty simple. Is there more? Sure. License: MIT
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.