Re: Autoincrement : how does it work / how to reset it

2003-02-01 Thread Adolfo Bello
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

Re: Autoincrement : how does it work / how to reset it

2003-02-01 Thread Zak Greant
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

Re: Autoincrement : how does it work / how to reset it

2003-02-01 Thread Benjamin Pflugmann
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

Re: Autoincrement : how does it work / how to reset it

2003-02-01 Thread Nasser Ossareh
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.

Autoincrement : how does it work / how to reset it

2003-01-31 Thread Robert Mena
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