Hi, is there any way to have MySQL automatically keep track of any changes I do with ALTER TABLE and later spit out the changes again?
I use one database (well, actually several, but that's not important here) for development and one database for the production system. Now, whenever I change the db structure, I have to jot it down in a text file and later copy-paste it to the production db. Of course, as anything that is done manually, this can (and already has) lead to problems if the text file is not kept in sync with the changes in the db. So what I'm looking for is something like this: ALTER TABLE tab1 ADD COLUMN acol int; ALTER TABLE tab2 ADD INDEX (anothercol); DISPLAY STRUCTURE CHANGES; RESET CHANGELOG; where of course the last two commands don't exist in MySQL. Jens --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
