if i compact a database will it reorder the id field that is auto_increment?
Thanks for any help
Thanks for any help
[mysql] compacting databases
It wont reorder the auto_increment field.
However, you should not have script depending on the number of rows in your db. E.g. you delete row no. 42 (auto_increment value and hence the id - 42) . id 43 would be then row no 42. If your script is based on calcultating the number of rows and adding one to it, the script would fail to deliver the required results.
However, you should not have script depending on the number of rows in your db. E.g. you delete row no. 42 (auto_increment value and hence the id - 42) . id 43 would be then row no 42. If your script is based on calcultating the number of rows and adding one to it, the script would fail to deliver the required results.
 |