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
On Fri, Jan 31, 2003 at 06:48:45AM -0800, 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
Hi.
On Fri 2003-01-31 at 06:48:45 -0800, [EMAIL PROTECTED] wrote:
Hi, I have been using autoincrement fields for some
time but was wondering how does it work in some
special situations.
Most of this depends on which MySQL version you use and which table
type, unfortunately. OTOH, for the
Auto_Increment will increment the last_INSERT_ID
(which in your case is 10)... so the num field of the
new entry will be 11.
--- Robert Mena [EMAIL PROTECTED] wrote:
Hi, I have been using autoincrement fields for some
time but was wondering how does it work in some
special situations.
Ex.
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
I read