Is there a good SQL software that will

[theking]

...scan and remove duplicates?

[theking]

Anyone...?

[Dvae]

remove duplicates from what?

[brandonstills]

mysql is my favorite sql software, it allows you to do pretty much anything a RDBMS does.

ask better questions, get better answers. hehe

[nnweb]

sql server 2005/2008 is the best out of the box sql server you can have.

mysql is shit.

[theking]

remove duplicates from what?

I thought that it is obivious...from an SQL data base.

[tranza]

Here's a bump for you...

[woj]

You don't need any additional software, just need a sql query to do it....

[MichaelP]

You don't need any additional software, just need a sql query to do it....

kudo

[Jet Redux]

...scan and remove duplicates?

give it up, Pathfinder

[Hell House Vic]

just search google for the right SQL query. No wait, YEAH I GOT A GREAT ONE, WANNA BUY IT FOR $100. j/k

[theking]

You don't need any additional software, just need a sql query to do it....

I suppose I should have added that will auto delete duplicates.

[woj]

I suppose I should have added that will auto delete duplicates.

remove duplicates then create a "UNIQUE" key...

[FightThisPatent]

...scan and remove duplicates?

you create a new table with the same structure, but set the primary key.

write a php or perl script that reads all the data from the "bad" table, and inserts into the "good" table.

any dupes will be rejected by the primary key

very simple process...


Fight the dupes!

[brandonstills]

define duplicate, duplicate of what?

[StuartD]

This thread is amusing. You might as well explain to him how to create 3d characters while you're at it.

He's a war vet who sits in front of his computer spouting political/military crap all day.
You may as well be speaking klingon to him rather than sql queries.

He asked for software to do it because... well, he can't.

[theking]

This thread is amusing. You might as well explain to him how to create 3d characters while you're at it.

He's a war vet who sits in front of his computer spouting political/military crap all day.
You may as well be speaking klingon to him rather than sql queries.

He asked for software to do it because... well, he can't.

I can do it but there are more than 80,000 records to go through thus I do not care to take the time to manually do it...got it sport.

[mikesouth]

ok databases dont have duplicates tables do

if you dont know the difference you have no business trying to do anything with it

sql is simply a language for adding deleting updateing and retrieving data from the tables It also has provisions for some data management and indexing

mysql IS an RDBMS

and a damn good one, probably better than almost anyone here will ever need. I remember some idiot once suggesting Oracle to manage a 1K member password file...now theres a moron.

If you know sql and any scripting language, writing a script to de-dupe a table is a cakewalk
If you don't, pay someone who does.

[tical]

dude

SELECT DISTINCT

[theking]

ok databases dont have duplicates tables do

if you dont know the difference you have no business trying to do anything with it

sql is simply a language for adding deleting updateing and retrieving data from the tables It also has provisions for some data management and indexing

mysql IS an RDBMS

and a damn good one, probably better than almost anyone here will ever need. I remember some idiot once suggesting Oracle to manage a 1K member password file...now theres a moron.

If you know sql and any scripting language, writing a script to de-dupe a table is a cakewalk
If you don't, pay someone who does.

I know the difference and I am somewhat familiar with SQL and have SQL admin with my host. I have modified php and cgi scripts but have never actually written a script from scratch. So I may have someone write a script for me or just live with a few duplicates which I think I know must exist. I just thought there may be software that would do the work for me. Apparently not.

Thanks guys for the input.

[mikesouth]

well remember databases consists of relations also called tables

relations consist of tuples also called records

tuples consist of attributes also called fields

databases cant have duplicates and tables are even unlikely to have duplicates, matter of fact duplicates generally refer to the attribute(s) that make up the primary key.

remember normal forms...in short a tuple must be indentifiable by the key, the whole key, and nothing but the key, so help me Codd

I worked for Informix for 5 years as a Sr Consultant and a Sr Instructor.

Theres a dozen ways to do what you want to do but if you dont know why ie your database design then yer just spinning your wheels.

[Dvae]

I thought that it is obivious...from an SQL data base.

Google is your friend...
http://www.google.com/search?q=%22re...utf-8&oe=utf-8

[brandonstills]

I can do it but there are more than 80,000 records to go through thus I do not care to take the time to manually do it...got it sport.

No! You haven't explained shit to us what you are trying to do. Got it sport? lol

[mrkris]

ok databases dont have duplicates tables do if you dont know the difference you have no business trying to do anything with it

We knew what he meant, no reason to be a douche.

[BradM]

You need to use psSql (PigshitSQL) to perform this function.

[mikesouth]

We knew what he meant, no reason to be a douche.

dont be a fucking idiot

If he doesn't know then he ends up with a trashed database and probably no backup.

you wanna see a douche try the fucking mirror