Skip to content
This repository has been archived by the owner on Sep 17, 2024. It is now read-only.

ignore auto_increment value but add auto_increment option if missing #40

Open
bourjaza opened this issue Oct 26, 2018 · 1 comment
Open

Comments

@bourjaza
Copy link

hello
I want to use mysqldiff to compare the schema of two sql tables (just the schema, not the data).
I run the command on two tables (table1 and table2), which are exactly the same except that table one as a column that has AUTO_INCREMENT option but the same column in table2 doesn't have this option.

I discovered that if I don't use the --skip-table-options, table that are the same but that have different AUTO_INCREMENT values will fail, so I must use this option. However, with this option, when comparing table1 and table2 will fail but the transformation doesn't add AUTO_INCREMENT. Is there an option to compare only the structure (including AUTO_INCREMENT) but not the values?

thank you

@bgmilne
Copy link

bgmilne commented Nov 2, 2018

This may be a duplicate of #15 , which has a patch/pull request/bug report ( https://bugs.mysql.com/bug.php?id=83838 )

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants