Revert Truncate table to clear table

[emteknetnz]

Revert this #11309 as it's lead to a large performance degradation when running PHPunit

Will need a different solution to fix the issue of mysql8 sometimes starting with an auto-increment of 2

If we go back to something like the original solution, make sure it includes an inline comment of WHY we're not using truncate so that future generations do not blindly just change it

PRs

• FIX Clear table logic for MySQL 8 #11319

[GuySartorelli]

PR merged