Re: Creating new table from distinct entries

2006-10-24 Thread Visolve DB Team
] To: mysql@lists.mysql.com Sent: Tuesday, October 24, 2006 12:47 AM Subject: Creating new table from distinct entries MySQL 4.1.21-community-nt I have a table in my database that has a Primary key on 2 fields (MyID and MyChange) and a field that indicates if there is a problem with the record

Creating new table from distinct entries

2006-10-23 Thread Alan Milnes
MySQL 4.1.21-community-nt I have a table in my database that has a Primary key on 2 fields (MyID and MyChange) and a field that indicates if there is a problem with the record (MyError)- I want to create a new table that only has unique MyIDs and where there is more than 1 I only want the