How to reset AUTO Increment in MySQL
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?
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.
Login | Sign Up
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'
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
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)
Angular FormGroup vs FormArray
Angular FormGroup vs FormBuilder
Angular FormControl vs ngModel
Angular FormControl dirty vs touched
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.
©2023 concretepage.com |