Reset ID to 1 again

Yii 2.0 General Discussions
1

I deleted all data from my database and when I create a data again it doesn’t go back from 1, how do I reset it to 1 again?

2
  1. Truncate or drop and create table again

or

  1. Mysql https://stackoverflow.com/a/8161848. Pgsql https://stackoverflow.com/a/8745101