Problem with Auto Increment feature of database tables

See more:

SQL

MySQL

server

SQLite

I have some database tables in which i made a column ''id'' a primary key with auto increment. I've been running into problems with accessing the data in the tables using say

Select   first_name From info Where id = 1

after clear all records in the table. It seems like the auto increment feature still continues from the last number it recorded before i cleared the database. Please can someone tell me how to make it start afresh to count after i've cleared the table. Thanks.