New Indexing

Timo Trallala posted 11 years ago in General

I've a little problem using heidisql. I'm testing a dynamic menu-contoll. To keep a cleary arrangement I wish to reindex a autoincement field.

Does anyone knowes a simple solution?

rosenfield posted 11 years ago
Under 'Export', the 'Data' combo box currently has these to offer:

- Replace (truncates existing data)
- Insert (fails on existing data)
- Insert new (ignores existing data)
- Update (updates matching data)

We could add another option:

- Append

Which would find all columns marked auto_increment and replace their contents with NULL in the exported file. The net effect would be that once imported, those rows would be assigned new autoincrement numbers.

Perhaps that would do what you want?

I don't have time to hack at it right now, but feel free to download the source codes and have a go at it. There's a developer's readme and all :).

Please login to leave a reply, or register at first.