Change next id download

[hiteq]

Hello
i should reset dth number of id of download. So for 2019 they must start from 1.
I have open db and in "id" of _phocadownload i have set 1 into "AUTO_INCREMENT" the i have click on Run but i see always the same number. So what's wrong?
Thanks

[Jan]

Hi, when you want to restart auto_increment values in your database, then the quickest method is to make

Code: Select all

TRUNCATE TABLE table_name;

But this will delete all data in the table, so before making it, the backup must be done. If you want to keep old data in database, there is no option to have two items with the same ID.

Jan

[hiteq]

Thanks for your replay. And do you thing it possible to add 2018, for example, to old download and reset the new? Thanks

[Jan]

The problem is, it is auto increment so if you add e.g. 2018 to 123, so it becomes 2018123 - then the next number is 2018124 not 2019001, it is just database autoincrement number which cares about not adding two the same values into database.

Jan