If you mean delete everything that is in the table (all the rows) then use this:
//PHP Code: อันนี้แบบลบทุกอย่างใน Table เลย
TRUNCATE TABLE tbl_name
but, if you mean just reset the auto_increment value:
[php]//PHP Code: อันนี้ไว้ set ค่า AUTO_INCREMENT
ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234
Code
this will put the next auto_increment value at 1234 unless you already have a row 1234 in which case SQL will find the next free greatest number or simply overwrite depending on version number
from http://tycoontalk.freelancer.com/php-forum/32507-reset-auto-increment-in-mysql.html
Load balance : Server 03
