Hi, You can try to use ALTER IGNORE TABLE syntax :
ALTER IGNORE TABLE your_table ADD UNIQUE(Id); Regards, Jocelyn Fournier ----- Original Message ----- From: "Rich" <[EMAIL PROTECTED]> To: "MySql" <[EMAIL PROTECTED]> Sent: Sunday, February 10, 2002 5:31 PM Subject: Duplicate Records > How does one go about removing one of two identical records in a MySQL > database? My mistake in an earlier database was not applying a unique > number to each record (1, 2, 3, ---). I know it's possible to use the > DISTINCT operator to show only one of the identical records in a result, > but that does not remove one of them from the database. > > One thought that I had would be to add a unique number to each record, > and that could probably be done manually, one record at a time, but is > there a way to automate the process so that unique numbers could be > assigned with one command? > > TIA > > Rich > > -- > [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
