Re: [PHP] Creating new table from distinct entries

This is definitely something you'll want to run by the MySQL mailing list. On Oct 19, 2006, at 10:02 AM, Alan Milnes wrote: PHP 4.4.4 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

[PHP] Creating new table from distinct entries

PHP 4.4.4 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 wa