Hey there, Awesome Customers!

Just a heads up: Our team will be out of the office on Monday, November 11th in observance of Armistice Day, but don’t worry—we'll be back in full swing on Tuesday, November 12th.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards,

TMS

Okay
  Public Ticket #1003132
delete
Closed

Comments

  •  5
    FoodCoop started the conversation

    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.

  • [deleted] replied

    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.


  •  5
    FoodCoop replied

    ok thank you.