On Fri, 2003-01-31 at 10:48, Robert Mena wrote: > Hi, I have been using autoincrement fields for some > time but was wondering how does it work in some > "special" situations. > > Ex. suppose I have an autoincrement field called num > and the last one has value of 10. > > I delete the last on and insert a new one. Which > value will it have ? 10 or 11
11 > > I read that if I issue a query delete * from table and > delete from table I have diferent results (in regards > to the auto increment field). Is this correct ? Try both. I don't know what you mean. Sorry. > Thanks. > PS. plese CC me directly since for some reason the > messages from the list are taking a while to get in my mailbox. Done! -- __ / \\ @ __ __ @ Adolfo Bello <[EMAIL PROTECTED]> / // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258 / \\ // / \\ / // // / // cel: +58 416 609-6213 /___// // / <_/ \__\\ //__/ // fax: +58 212 952-6797 www.bisapi.com // pager: www.tun-tun.com (# 609-6213) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php