On Wednesday 14 August 2002 17:32, you wrote:
> On Wed, 14 Aug 2002 17:03:32 +0300
>
> "adi" <[EMAIL PROTECTED]> wrote:
> > Salut,
> > Am o tabela mysql cu campul NR:
> > Field name     Type    Allow nulls?    Key            Extras
> > NR                 int(11)    No                Primary
> > auto_increment
> >

From Google: http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html

"Steve
: I finally figured out how to reset the AUTO_INCREMENT counter: ALTER TABLE 
tbl_name AUTO_INCREMENT = 1; This will reset the counter to the current 
maximum value."

-- 
Gabriel Dumbrava
Network Administrator
EduLib Soft, srl
Craiova, Romania
 
Tel: + 40 251 413496
Fax: + 40 251 418935
Email: [EMAIL PROTECTED]
Url: www.edulib.ro
---
Pentru dezabonare, trimiteti mail la
[EMAIL PROTECTED] cu subiectul 'unsubscribe rlug'.
REGULI, arhive si alte informatii: http://www.lug.ro/mlist/


Raspunde prin e-mail lui