Re: How to Reset a field

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. --

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

RE: How to Reset a field

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

Re: How to Reset a field

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

Re: How to Reset a field

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: