Timeline for How to use "TRUNCATE TABLE" MySQL statement?
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 13, 2016 at 9:03 | comment | added | skndstry | 1. linked forum entry code did not work because of a typo. 2. trac ticket just talks about return values from ddl statements. | |
| Apr 27, 2012 at 5:37 | comment | added | goodseller | I found it: $wpdb->query("ALTER TABLE tableName AUTO_INCREMENT=0") Thanks @MathSmath :) | |
| Apr 27, 2012 at 4:02 | comment | added | goodseller | @MathSmath Yeah~ That's true, so true. However is there any way to do so? | |
| Apr 26, 2012 at 19:53 | comment | added | MathSmath | @goodseller Not sure what you're trying to do, so it might not be important to you--but note that DELETE does not reset any auto-incrementing columns. So even though your table will be empty, the next item ID will pick up where the last auto- incremented value left off. | |
| Apr 26, 2012 at 14:51 | comment | added | goodseller | Well, maybe I use DELETE instead of truncate. | |
| Apr 26, 2012 at 14:51 | vote | accept | goodseller | ||
| Mar 9, 2018 at 9:18 | |||||
| Apr 26, 2012 at 13:33 | history | answered | Aaron Wagner | CC BY-SA 3.0 |