Reset auto_increment after deleting row
TenTen Peter
-- Table structure for table
Hi i know this question has been asked before but i'm asking it differently, what i want is to reset the auto_increment column, after deleting a row in a table. if i have table with 51 rows and i delete row 48, i want row 49 to reset to 48,50 to 49 etc.
i have tried using alter table but that insert data where the row was deleted, i want something that will shift the order.
-- Table structure for table torrents
CREATE TABLE IF NOT EXISTS `torrents` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Title` varchar(250) NOT NULL,
`Kat_Link` varchar(250) NOT NULL,
`Tpb_Link` varchar(250) NOT NULL,
`Lime_Link` varchar(250) NOT NULL,
`ImgUrl` varchar(250) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB;
what i want is to run a select from table where ID = $id lmit 8 if the ID doesn't exists i get less than 8 rows.
Junius L.
It's going to be difficult to achieve that just use limit with your select statement, what you want is to get number of rows(e.g 8 rows) by ID, if that ID doesn't exists, your select statement is going to give you less rows than you want.
SELECT * FROM table LIMIT $r,$s // here you are guaranteed that you'll get 8 rows all the time
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
how to reset the value of a AUTO_INCREMENT row in a mysql table
- 2
how to reset the value of a AUTO_INCREMENT row in a mysql table
- 3
Reset Auto_Increment Value After Data Delete MySQL
- 4
How to reset the AUTO_INCREMENT
- 5
Reset row numbers after deleting an item from datagrid
- 6
How to reset AUTO_INCREMENT in MySQL?
- 7
Reset auto_increment based on datetime column
- 8
Reset auto_increment in insert into statement
- 9
How to reset autoincrement value after deleting 1 row of column from it, on sqlite java android?
- 10
JTable not repainted after deleting a row
- 11
"Reset" buildNumber after deleting old builds in TeamCity
- 12
Reset rowid field after deleting rows
- 13
How to reset AUTO_INCREMENT in MySQL for all tables within a DB?
- 14
MySQL rearange auto increment after row is deleted
- 15
GridView is hiding after Row Deleting Event
- 16
getLocalRow gives wrong data after deleting row
- 17
SQLite Database not updating properly after deleting row
- 18
Deleting all cells in row after blank space
- 19
renumber appended table row in javascript after deleting
- 20
Update Recyclerview List After Deleting Row
- 21
Reset identity seed after deleting records in SQL Server
- 22
Adding to a table using MVC 5, and reset Id after deleting records
- 23
reset id(primary key) after deleting record in sql
- 24
Yii 1 - deleting row after saving row in other table
- 25
Everytime when the rows in table are deleted, The Auto_increment will be reset to 1 at the next insert
- 26
How to update auto-increment field after removing a row?
- 27
In Angularjs, how to update table data after deleting a row from it
- 28
UITableViewController ignores tap after deleting row in iOS7
- 29
Refresh custom cursor adapter after deleting database row
Comments