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.