On Mon, 16 Aug 2004 11:36:32 -0400, [EMAIL PROTECTED] said: > It all depends on which values of f1 you want to ignore. > > f1 f2 f3 > ----- ----- ------ > val1-1 val2 val3 > val1-2 val2 val3 > val1-3 val2 val3 > > Which value of f1 would you want in your new table? Which ones to ignore?
I want the DISTINCT to ignore the f1 column completely. But I want all 3 cols. ie. the entire row selected though. Pretend that f1 is a unique PK it'll always be different, I want to DISTINCT to ignore it, so if 2 or mores row have dup f2 *and* f3 Distinct will let only one through. > Are there other columns (beyond these 3) to move as well? Nope. Just 3 cols. Thanks > > Yours, > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > "leegold" <[EMAIL PROTECTED]> wrote on 08/16/2004 11:29:33 AM: > > > say I'm selecting distinct (non-duplicate) rows for insertion, > > > > insert into original_table select distinct * from new_table > > > > these tables have 3 fields/row. Per the above code all 3 fields are > > evaluated by "distict *" . > > > > But my question is: I want to ignore field1, therefore I only want to > > test if any rows have field2 *and* field3 as dups - that would be my > > distinct test and then do the insert based on that. Test f2 and f3, not > > f1. > > > > What the sql? Help is greatly appreciated. > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]