Thank you.
--- In php-list@yahoogroups.com, William Piper <[EMAIL PROTECTED]> wrote: > > Michael Pakay wrote: > > > > > > 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. > > mysql_insert_id will tell you what the last entry was. To my knowledge, > there is nothing that will tell you what the next id will be. > > There is no reason that the increment will return to 0 unless you > truncate the table or you are using your own programatic incrementer > instead of mysql's auto_increment. > > Billy P. >
