Hi,
Quote:
When I tried to reset it I got a message “Invalid default value for 'ID'” which is my index field
Auto-increment column must be indexed, and it cannot have a DEFAULT value. Refer http://dev.mysql.com/doc/refman/5.6/en/create-table.html
If you enable the option “With Indexes” in “Duplicate Table” then the Auto-increment column will be indexed. Please check this option as shown in the attached image.
Thanks,
Ashwin A