Truncating data in custom tables

Support
#1

Summary

This works to remove all entries in a custom table:

$modx->removeCollection(‘objectName’, array());

but the auto-increment doesn’t get reset to 0, like it does if you use the “truncate” command in mySql. Is there some way to reset auto increment in MODX?

#2

Using the truncate command.

#3

OK, I found this and it works:

    $modx->exec("TRUNCATE TABLE {$modx->getTableName('Watering')}");

Is that still going to work in MODX 3?

1 Like
#4

$modx->exec('TRUNCATE TABLE ' . $modx->getTableName($class));

#5

Yes, that will still work.

#6

Great.

So, why doesn’t removeCollection reset the autoincrement? Why would anyone not want to reset that if they are deleting all the entries in a table?

#7

Remove collection is for running a DELETE with criteria. Why WOULD it reset the auto-increment? How would it know all records were removed?

#8

I guess that answers my question! Thanks.