How to reset AUTO Increment in MySQL

Database

Sikha

Asked on November 29, 2014

Hi, How can I reset AUTO Increment in MySQL database.

In my database, auto increment is incremented like 2000, 2001 where as max element is 500.

How to fix it safely?

Arvind

Replied on November 29, 2014

Suppose you have a table A, and you need to reset the Auto Increment, run the query as below.

ALTER TABLE A AUTO_INCREMENT=500

I would suggest that take the backup of database before running the query.

Write Answer

Delete Table in MongoDB
How to show table data in MongoDB
How to create user and password in MongoDB
How to create database in MongoDB
command to check primary key in oracle using query
java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'USERS'
java.lang.ClassNotFoundException: org.sqlite.JDBC
Difference between SQLite and MS Access
Define ACID Database Properties
java.sql.SQLException: Invalid column index
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
java.sql.SQLSyntaxErrorException: ORA-00928: missing SELECT keyword
How to find minimum cover for any set in DBMS?
What are set of FDs for the relation in DBMS?
Can anyone help me in DBMS? I am not able to understand what the question mean?
Neo4j Cypher Query: How to fetch graph related to entity?
find second max salary in SQL
Query/command to select second max value in a list using sql
Example of DBMS? Which is used in present industry?
sql plus-- how to drop all the tables at a time in a data base systems
Spring +Hibernate integration db connection using hibernate.properties
core java
command to clear screen in oracle sql plus
What is the Database and what is the actual need of Database?

Latest Forum Post

NullInjectorError: No provider for ActivatedRoute! (Angular)
error NG8002: Can't bind to 'routerLink' since it isn't a known property of 'a' (Angular)
Property has no initializer and is not definitely assigned in the constructor (Angular)
package javax.servlet.annotation does not exist (Java EE)
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder" (Java EE)

About Us

We are a group of software developers.
We enjoy learning and sharing technologies.
To improve the site's content,
your valuable suggestions
are most welcome. Thanks
Email : concretepage@gmail.com

Mobile Apps

SCJP Quiz

ConcretePage.com

How to reset AUTO Increment in MySQL

Write Answer

Related Post

About Us

Mobile Apps