auto_increment help
#2

If you modify the value of auto increment in a production server, it will result in error for duplicate primary key if you attempt to create new houses and keep the old ones. If `id` is really not a primary key, it should have been.

Use it in a CAREFUL and CAUTIOUS way only if you want to delete all the data from the table and start over.
pawn Код:
ALTER TABLE `house` AUTO_INCREMENT=1;
Reply


Messages In This Thread
auto_increment help - by ,TomY' - 11.07.2018, 07:43
Re: auto_increment help - by Calisthenics - 11.07.2018, 07:49

Forum Jump:


Users browsing this thread: 1 Guest(s)