mysql check auto increment value
Dec 22, 2011 · When Truncation is used, it resets any AUTO_INCREMENT counter to zero
In below demo we have covered
This is given as follows −
AUTO_INCREMENT و إليك بعض الأمثلة: في قواعد بيانات Access و SQLite نكتب
في النهاية, مهما كان نوع قاعدة البيانات
Retrieve a record which has the highest value in this column using the MAX function
4
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
Anda juga dapat me-reset auto increment secara langsung melalui PHPMyAdmin