Aktualności
Aparat sony lustrzanka, fck
Note: This function returns a copy of the passed arguments only, and does not account for default (non-passed) arguments.
Willa Zygzak
"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."
Login
- Nie masz jeszcze konta?
- Zarejestruj nowe konto.
O nas
HEj ho.
Maciek yy
For those that are looking to "reset" the auto_increment, say on a list that has had a few deletions and you want to renumber everything, you can do the following.
Maciek yy
DROP the field you are auto_incrementing.
ALTER the table to ADD the field again with the same attributes.
Maciek yy
You will notice that all existing rows are renumbered and the next auto_increment number will be equal to the row count plus 1.
Maciek yy
(Keep in mind that DROPping that column will remove all existing data, so if you have exterior resources that rely on that data, or the numbers that are already there, you may break the link. Also, as with any major structure change, it's a good idea to backup your table BEFORE you make the change.)
Maciej, Wszysko ok.
2010-10-22

