Get MySQL database structure alter queries

Question

I'm working on a version control program, and I would like to implement database structure versioning as well. Is there a way to get a list of all the queries that have altered the databse structure in any way?

For example I added a column to the 'users' table called 'remember_token'. Is there a way I can get the specific query that was executed on the MySQL server in order to add that column?

have you looked in the history ?

indian
– indian

2014-11-10 10:30:52 +00:00
Commented Nov 10, 2014 at 10:30 — indian
– indian, Commented Nov 10, 2014 at 10:30

Rahul · Accepted Answer · 2014-11-10 10:41:34Z

2

You may want to enable the mysql query log and then filter on ALTER queries or anything you need

edited Nov 10, 2014 at 10:41

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

answered Nov 10, 2014 at 10:33

Florent

4292 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get MySQL database structure alter queries

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related