How to Reset the AUTO_INCREMENT (Auto-Increment Primary Key) of a Table?

Translated
2
| username: 我是咖啡哥 | Original post link

It seems impossible. I went through the documentation and conducted several tests, but none were successful. Using “alter table … auto_increment” gives a warning. Moreover, the auto_increment value shown in “show create table” does not appear to be the current auto-increment value.