You are not logged in.
Pages: 1
Topic closed
Hi,
I am using Glpi, i need to reset the auto increment counter to ZERO which is used for tracking ID's.
Please let me know how to do it???
Offline
ALTER TABLE thetable AUTO_INCREMENT=0
For table's name it's depend of your version of GLPI used
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline
ALTER TABLE thetable AUTO_INCREMENT=0
For table's name it's depend of your version of GLPI used
Hi,
I droped the table and created a new table with AUTO_INCREMENT=0
Its working fine.
Anyways thanks for the reply.
Offline
OK. I close
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline
Pages: 1
Topic closed