If the columns are defined as not null, just add a unique index on all the fields. alter table ignore add unique(col1.col2.col#);
walt wrote: >Does anyone know a good way find and remove duplicate records from a table? >I can create an identical table structure and use a script to pull records >from the existing table and insert them into the new table if they are not >duplicates, but I'd rather not do it that way. Here is an example of an sql >script I use for Oracle databases > >delete from employee a >where rowid < ( >select max(rowid) >from employee b >where b.COL1 = a.COL1 >and b.COL2 = a.COL2 >and b.COL# = a.COL#); > >sql, query > >Thanks in advance! > --------------------------------------------------------------------- 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
