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 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 of the last value.
How I can Reset the field "ID"
thanks ------------------------------- Hola
Yo tengo una db con una tabla usuarios, yo borre todos los campos de la db pero el campo "id" que un autonumerico que se incrementa automaticamente se queda con el valor del ultimo campo, como puedo restablecer el valor de Id a 0 cada vez que limpie la db???
gracias
Yusdaniel
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]