javascript - In Sequelize model.destroy({ truncate: true }) does not reset primary key - Stack Overflow

admin管理员组

文章数量:1206189

In Sequelize, I am using this function model.destory({ truncate: true }), it delete all data in table. But the issue is that it does not reset the primary key sequence in table which should be set to Zero. I am using Mysql. Some said that Mysql automatically reset the primary key sequence, but it is not happening in my case.

Here is my code:

db.Booking.destroy({ truncate: { cascade: false } })
    .then(() => {
      res.json({ status: true });
    }, (err) => {
      console.log('truncate: ', err);
      res.json(err);
    });

In Sequelize, I am using this function model.destory({ truncate: true }), it delete all data in table. But the issue is that it does not reset the primary key sequence in table which should be set to Zero. I am using Mysql. Some said that Mysql automatically reset the primary key sequence, but it is not happening in my case.

Here is my code:

db.Booking.destroy({ truncate: { cascade: false } })
    .then(() => {
      res.json({ status: true });
    }, (err) => {
      console.log('truncate: ', err);
      res.json(err);
    });

• javascript
• mysql
• node.js
• express
• sequelize.js

Share Improve this question Follow edited Nov 2, 2020 at 13:59 coder 90611 gold badge1212 silver badges1919 bronze badges asked Sep 29, 2016 at 8:46 user6898264user6898264 1

• Related for SQLite: stackoverflow.com/questions/55966627/… – Ciro Santilli OurBigBook.com Commented Jun 17, 2021 at 10:38

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 19

You're not using the correct syntax:

db.Booking.destroy({ truncate: { cascade: false } })

That should be:

db.Booking.destroy({ truncate : true, cascade: false })

See the documentation.

if you are, in any case, using a custom foreign key, use this instead

db.Booking.truncate({cascade: true, restartIdentity:true})

as destroy would not work at will with custom foreign key

this one is nested pretty deep in the documentation

See here

本文标签： javascriptIn Sequelize modeldestroy( truncate true ) does not reset primary keyStack Overflow