Yii2 reset db ids when transaction rollback

Question

I've noticed by transactions rollbacks, primary key ids keep growing. Is it possible somehow to reset them (auto increment)?

score 0 · Accepted Answer · answered Jan 31 '16 at 01:28

0

I guess you are using delete() in your safeDown() method. if you want to remove all data from the table, you should use truncateTable() or you can write your own slq with execute().

answered Jan 31 '16 at 01:28

Clyff

4,046
2
17
32

Unfortunately I can't truncate, but this question seems lame, according to this thread: http://stackoverflow.com/questions/2214141/auto-increment-after-delete-in-mysql – user2511599 Jan 31 '16 at 07:59

score 0 · Answer 2 · answered Nov 21 '17 at 13:34

Try set AUTO_INCREMENT to 1

public function down()
{
    $this->delete('{{%email}}', ['id' => [1, 2, 3, 4, 5, 6, 7, 8, 9,]]);
    $this->execute('ALTER TABLE {{%email}} AUTO_INCREMENT = 1');
    // When you insert any other (not NULL or 0) value into an AUTO_INCREMENT column,
    // the column is set to that value and the sequence is reset so that the
    // next automatically generated value follows sequentially from the largest column value.
}

Yii2 reset db ids when transaction rollback

2 Answers2