Re: Command for getting back an auto_increment field?

2004-04-30 Thread Egor Egorov
Leandro Melo [EMAIL PROTECTED] wrote: If it`s a InnoDB table :-? my case If you want to start auto_increment sequence from the beginning, you must recreate InnoDB table. --- Paul DuBois [EMAIL PROTECTED] escreveu: At 12:27 -0300 4/29/04, Leandro Melo wrote: Hi, i got a table wich its pk

Re: Command for getting back an auto_increment field?

2004-04-30 Thread Paul DuBois
At 14:48 +0300 4/30/04, Egor Egorov wrote: Leandro Melo [EMAIL PROTECTED] wrote: If it`s a InnoDB table :-? my case If you want to start auto_increment sequence from the beginning, you must recreate InnoDB table. To add to this, I'll mention something else that is relevant in the context of

Command for getting back an auto_increment field?

2004-04-29 Thread Leandro Melo
Hi, i got a table wich its pk is an auto_increment field. I have 10 elements in this table, wich makes the pk_id field = 10. I inserted incorrectly anoter row in this table (the 11th) and imediately deleted it. Although, i'd like that the next time i insert a row in this table, it's index be

Re: Command for getting back an auto_increment field?

2004-04-29 Thread Paul DuBois
At 12:27 -0300 4/29/04, Leandro Melo wrote: Hi, i got a table wich its pk is an auto_increment field. I have 10 elements in this table, wich makes the pk_id field = 10. I inserted incorrectly anoter row in this table (the 11th) and imediately deleted it. Although, i'd like that the next time i

Re: Command for getting back an auto_increment field?

2004-04-29 Thread Josh Trutwin
On Thu, 29 Apr 2004 12:27:46 -0300 (ART) Leandro Melo [EMAIL PROTECTED] wrote: Hi, i got a table wich its pk is an auto_increment field. I have 10 elements in this table, wich makes the pk_id field = 10. I inserted incorrectly anoter row in this table (the 11th) and imediately deleted it.

Re: Command for getting back an auto_increment field?

2004-04-29 Thread Leandro Melo
If it`s a InnoDB table :-? my case --- Paul DuBois [EMAIL PROTECTED] escreveu: At 12:27 -0300 4/29/04, Leandro Melo wrote: Hi, i got a table wich its pk is an auto_increment field. I have 10 elements in this table, wich makes the pk_id field = 10. I inserted incorrectly anoter row in