> my coulmn (id) is an auto_increment coulmn and lets say that i have 100
> entries, so the problem is that when i delete all entries on my table, the
> column (id) starts from 101 ,shouldn't is starts from 1 again!
> please i need help with this

Use truncate table, it will reset the auto_incement.


-- 
Greg Donald
http://destiney.com/



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to