Sequel-ace: Copy as SQL insert without primairy keys

[cappadaan]

Currently there is an option "Copy as SQL insert" in the contents view of a table.

I really would like to see the option "Copy as SQL insert without primairy keys" added.

There are many cases that I need to copy rows from 1 database to another, which are similar structure, but with different data and different primairy keys. In the current application I have to manually remove all the primairy key data before I can run the Insert command.

[MacTrophy]

I am wondering, would this be skipping all primary key values or only those that are auto-increment? I do see the use for skipping auto-increments (and had this need in the past myself a couple of times) but for other types of keys I am wondering.

[cappadaan]

I meant the auto-increment keys only

[jamesstout]

so, if a non AUTO_INCREMENT column is say a UNIQUE KEY, then you would still want to copy that?

[jamesstout]

And would you want this to be a global option in prefs or an extra menu item/right click option?

[cappadaan]

Only auto increment, the rest of the data should be copied as is.

An extra menu item/right click would be most useful here

[jamesstout]

Something like this?

[cappadaan]

Wow, this is the perfect solution! Good job!

[jamesstout]

@Sequel-Ace/all You ok with this? The menu item name ok?

[Jason-Morcos]

@Sequel-Ace/all You ok with this? The menu item name ok?

I'm okay with it! Go ahead and PR
I don't love the ctrl+shift+c keystroke but honestly can't think of a better one! Maybe shift+alt+cmd+c instead?

[jamesstout]

shift+alt+cmd+c does something weird. OK with shift+control+command+c?

[Jason-Morcos]

shift+alt+cmd+c does something weird. OK with shift+control+command+c?

Yup! Works for me!