select max(idfield) from table
> -----Original Message----- > From: Brad Harriger [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 7:32 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Access to MySQL Conversion question > > > I have several MS Access databases that I need to convert to MySQL. > Each table is indexed on an ID field. How do I find the last index > number in the existing table so that I can increment it for the next > record that is added? > > Thanks, > > Brad > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]