Я хотел бы получить запрос с использованием схемы база данных в MySQL
that shows the difference between the columns, triggers and stored procedures between two database schema's: production and development.
Query, not tools
I've seen Compare two MySQL databases
Which lists the tools that can perform this task, but I would like to know is if there is a query that can perform this task.
Please only suggest queries, I really do not want to know about tools, command line hacks or such.
I am looking to see if the production database and development database are out of sync.
And which fields, procedures etc where added or changed, so I can update the production database if I roll out a new update of the client software that uses the database.
I'm using MySQL 5.1 latest version.