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