New Indexing
| User, date | Message |
|---|---|
|
Written by Timo Trallala
6 years ago Category: General 1 posts since Sun, 21 Jan 07 |
Hi, 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? thanx tt |
|
Written by rosenfield
6 years ago 127 posts since Wed, 24 Jan 07 |
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. |