duplicates

Is this a good solution to remove duplicate MySQL rows?

I saw the solution to create an alternate temporary MySQL table with unique rows, but I didn't like that idea, as my tables are very large and would be a hassle to move them (and would create huge problems if there would be errors during the move). I did, however, find the following. What do you think of this (where the duplicates to ch...

LINQ checking for duplicate objects (excluding ID)

Hi All, I am using LINQ to SQL (SQL Server) with C#. I have a table called "Cars" which automatically becomes the LINQ class/object called "Car". All well and good. Each car has a number of fields, say CarID(primary key int), EngineID, ColourID. I have 10 existing rows in the Cars table. Using all the cool LINQ stuff, I create a new...

choosing the element with more duplicates on an array in plain C

This question brings me back to my college days, but since I haven't coded since those days (more than 20 years ago) I am a bit rusty. Basically I have an array of 256 elements. there might be 1 element on the array, 14 or 256. This array contains the usernames of people requesting data from the system. I am trying to count the duplicat...

Remove duplicate elements off a multi-dimension array in php

Hay guys, i have an array contain this data Array ( [id] => Array ( [0] => 1 [1] => 10 [2] => 4 ) [age] => Array ( [0] => 1 [1] => 1 [2] => 2 ) ) Now i want to remove duplicates from the ['age'] and leave the first one ...

Removing duplicate byte[]s from a collection.

This will probably be an extremely simple question. I'm simply trying to remove duplicate byte[]s from a collection. Since the default behaviour is to compare references, I tought that creating an IEqualityComparer would work, but it doesn't. I've tried using a HashSet and LINQ's Distinct(). Sample code: using System; using System.Co...

Duplicate Symbol XCode duplicate library for same library?

Do you have any idea? Why XCode compilation give this result? ld: duplicate symbol _kJSONDeserializerErrorDomain in /Users/Shared/_BUILDS_/Debug-iphoneos/libLACDLibrary.a(CJSONDeserializer.o) and /Users/Shared/_BUILDS_/Debug-iphoneos/libLACDLibrary.a(CJSONDeserializer.o) ...

How to apply patches on the top of a git tree preventing duplication?

Hello everybody, I'm seeking advice for a problem that I thought to be simple, and it might be simple indeed by creating a small script, but I think there should already be a way to do that with git/quilt/stgit. I'm not exactly good at git and this is causing some issues to me. My problem: I've got a git tree (linux kernel) and a numbe...

Compare arrays and remove duplicates, in Ruby?

What would be the easiest way to compare multiple arrays, and remove duplicates? So (arrays inside arrays in this case)... a = [[2, 1], [3, 3], [7, 2], [5, 6]] b = [[2, 1], [6, 7], [9, 9], [4, 3]] c = [[2, 1], [1, 1], [2, 2], [9, 9]] d = [[2, 1], [9, 9], [2, 2], [3, 1]] ...would come out (with priority given to array a, the...

In MySQL, how do I write a query to skip a duplicate row while inserting, when there's no unique field (primary key)?

I am trying to insert rows into a table that has no unique field or primary key. How can I write a query that will simply ignore the insert if there already exists a row with the exact same values on all fields -- a duplicate row? Thanks. ...

SQL SELECT: value that occur > 1

I'm trying to select duplicates from this table: snr zip 01 83 02 82 03 43 04 28 Expected result is just empty table. Cuz it got no duplicates. I've tried with this query: SELECT snr, zip FROM student GRUOP BY snr HAVING (COUNT(zip) > 1) But it says that syntax is error, and that I'm trying to query an aggregate functions, etc.. ...

How to eliminate "duplicate" URL MySQL rows which may or may not start with www?

I've been using a Drupal module called FeedAPI De-Dupe to remove duplicate records from my site's (MySQL) database. The module does a great job, but I'm still left with some "duplicates" when the URLs sometimes contain "www" and sometimes don't. The code handling the duplicate detection is: case 0: //url-based $sql = "SELECT n.nid ...

Duplicate Identifier Error

I was just coding on my Lazarus, without changing nothing on the TForm declarations. Then I tried to test my application, but on the compilation I got this error: TomAct.lpr(11,43) Error: Duplicate identifier "TOMACT" TomAct.lpr(15,32) Error: Identifier not found "TForm1" TomAct.lpr(15,39) Error: Identifier not found "Form1" TomAct.lpr(...

Find duplicates in database and rename one

I've got a table in Postgres that is chock full of articles. The articles have a url slug associated with them, which are used to display them as example.com/pretty_name as opposed to example.com\2343. Unfortunately, when I started out, I enforced a unique constraint on urls, but neglected to do so on a case insensitive basis, and I'd l...

How do I remove duplicate strings from an array in C?

Hello, I have an array of strings in C and an integer indicating how many strings are in the array. char *strarray[MAX]; int strcount; In this array, the highest index (where 10 is higher than 0) is the most recent item added and the lowest index is the most distant item added. The order of items within the array matters. I need a...

Finding duplicate records in mysql based on a bitmask.

I have a mysql table which stores maintenance logs for sensors. I'd like to design a query that finds instances where a given sensor was repaired/maintained for the same reason. (Recurring problem finder.) My table (simplified) looks like this: id name mask == ==== ==== 11 alpha 0011 12 alpha 0010 13 alpha ...

Help please. make the manual slideshow repeatable?

Any one help please the webpage is: http://weblink.computersforpeople.info/users/1/properties/518/images/2869 How can I make it repeatable, I mean when I click the next button on the last photo, it can go to the first one again. have asked before, but still couldn't solve. could someone help please. Many thanks!!! ...

Delete duplicate rows in MySQL table but foreign key relationship exists?

How can I delete duplicate rows from a MySQL table when a foreign key relationship has already been setup up on those rows. Can the duplicates be merged somehow and then foreign key updated with the new value? ...

python dict remove duplicate values by key's value?

A dict dic = { 1: 'a', 2: 'a', 3: 'b', 4: 'a', 5: 'c', 6: 'd', 7: 'd', 8: 'a', 9: 'a'} I want to remove duplicate values just keep one K/V pair, Regarding the "key" selection of those duplicated values, it may be max or min or by random select one of those duplicated item's key. I do not want to use a k/v swap since ...

Item duplication problem

Hi friends, My goal is to add a insert new value to a column where my column values are as follows 100 * 100 150 * 150 200 * 200 200 * 200 I get the following error: Item has already been added. Key in dictionary: '200 x 200' Key being added: '200 x 200' For next code: SortedList sortedList = new SortedList(); foreach (ListI...

Need to remove duplicates values from array during foreach

Hey All, Just wondering if you can help me out. I have a column with rows of tags. In each row i have each tag separated with a comma and space. for example: BMW M5, Leather Seats, 24 Inch Wheels, etc. What i need to do is loop through the array, explode it, and then print the values to the page. So far I have been able to do it; how...