ConcretePage.com
HOME
ALL TUTORIALS
JAVA 8
SPRING BOOT
ANGULAR
ANDROID
Q&A
|
Sign In
Ask Question
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
Login | Sign Up
Related Post
Set MySQL PATH in macOS
Start/Stop/Uninstall MySQL on macOS without Terminal
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
Unlabeled ordinal parameter ('?' rather than ?1)
(Hibernate)
Angular FormGroup vs FormArray
(Angular)
Angular FormGroup vs FormBuilder
(Angular)
Angular FormControl vs ngModel
(Angular)
Angular FormControl dirty vs touched
(Angular)
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
Utility
Age Calculator