How AUTO INCREMENT property works in MySQL or MariaDB – MySQL Developer Tutorial

Auto increment in mysql is the property on column that is used to auto insert the number in column and increment automatically. In below demo we have covered below topics related to Auto increment in mysql.

1) AUTO_INCREMENT starts from 1 if you have not put the value
2) If you have manually added the value then next number will be from that larger
value.
3) Delete does not reset the AUTO_INCREMENT
4) Truncate will reset the AUTO_INCREMENT.

link to scripts used in MySQL Developer Tutorial / MariaDB developer Tutorial
http://www.techbrothersit.com/2018/12/how-auto-increment-property-works-in.html

MySQL Tutorial for Beginners
MySQL Development Tutorial
MySQL Tutorial for developers
MySQL Development Training
MySQL training for developers
MySQL Workbench Tutorial
MySQL DBA Certification Training
MySQL DBA Tutorial Step by Step
MySQL DBA Training online free
MySQL Real Time DBA Tutorial
MySQL Administration Course step by Step
MySQL Tools for Development and Admin