> 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]