I recently changed hosting companies and recreated my MySQL database with all tables and data. Several tables use an Auto_Increment field as my PrimaryKey, (one up increment)
How can I determine the next value to make sure the trigger was not reset to 0 which will create a duplicate Primary Key, rejecting the record? I'm using phpMyAdmin from the cpanel. Any help will be appreciated.
