SA-MP Forums Archive
auto_increment help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: auto_increment help (/showthread.php?tid=656250)


auto_increment help - ,TomY' - 11.07.2018

Hi all. If it possible, to use this code in pawno? I mean, that I use it in sql, but if it possible, to use it with command in server?

Код:
ALTER TABLE `house`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=0;


Re: auto_increment help - Calisthenics - 11.07.2018

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;