Hello reader's! if you already using the mysql then you have seen the id with autoincrement always add up. forevery new entery the id will increase even if you drop the table.so if you want to reset ...

For InnoDB you cannot set the auto_increment value lower or equal to the highest current index. This is the sample example: Here you can see that I am deleting records from table user_invites having 5 ...

In a table with various fields, if you can insert a new one, type int, you cannot select auto_increment and primary key button at the same time You get an error: SQL query: ALTER TABLE `Jefes` ADD ...