Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
Hi,
I have a table where I defined wdt_id as ID column for editing.
I use this row for a current number. If I am adding a new row, the value is increasing (auto increment in the sql table is on). This is ok an useable.
But if I delete a row (deleting the yellow row) in the table then the auto increment value in the My_SQL table is not decreasing.
The result is, that I have not a uniform numbering in my table.
Can you help?
Best regards
Siegfried
PS Congratulation to the plugin. It is really the best to work with tables and I tried a lot of such plugins.
Hi Uebes,
This is limitation on MySQL side and not ours. From their documentation:
You cannot reset the counter to a value less than or equal to the value that is currently in use. For both InnoDB and MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum AUTO_INCREMENT column value plus one.
There is a couple solutions to affect this behaviour but we are not recommending it because they are workarounds.
ok thank you.