[,TomY']

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;

[Calisthenics]

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;