"Yusdaniel Rodriguez Espinosa" <[EMAIL PROTECTED]> wrote:
> I have a db with table "usuarios" I erased all data in this table but "Id"
> is a autoinc and he have the value of the last value.
>
> How I can Reset the field "ID"
See http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html at the very end
Donde estas tratando hacer eso, en el command line cierto? O estas
trabajando con mysql front o con algun otra programa? Perdon estoy muy nuevo
no entiendo donde hacer alter table usuarios auto_increment = 1, mil
gracias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
You could also have done this:
TRUNCATE TABLE usarios;
That will drop the table completely and then recreate it anew (and
empty). It will give you a fresh start.
--V
Victor Pendleton wrote:
Try
alter table usuarios auto_increment = 1;
-Original Message-
From: Yusdaniel Rodriguez Espinosa
Try
alter table usuarios auto_increment = 1;
-Original Message-
From: Yusdaniel Rodriguez Espinosa
To: [EMAIL PROTECTED]
Sent: 8/23/04 9:15 AM
Subject: How to Reset a field
Hello
I have a db with table "usuarios" I erased all data in this table but
"Id"
is a autoinc and he have the value
