Is there a good SQL software that will - GoFuckYourself.com

theking · 06-26-2008, 11:08 PM

...scan and remove duplicates?

theking · 06-26-2008, 11:27 PM

Anyone...?

Dvae · 06-27-2008, 02:56 AM

remove duplicates from what?

brandonstills · 06-27-2008, 03:05 AM

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 · 06-27-2008, 03:51 AM

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

mysql is shit.

theking · 06-27-2008, 10:16 AM

Quote:

Originally Posted by Dvae

remove duplicates from what?

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

tranza · 06-27-2008, 11:50 AM

Here's a bump for you...

woj · 06-27-2008, 12:52 PM

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

MichaelP · 06-27-2008, 12:57 PM

Quote:

Originally Posted by woj

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

kudo

Jet Redux · 06-27-2008, 12:58 PM

Quote:

Originally Posted by theking

...scan and remove duplicates?

give it up, Pathfinder

Hell House Vic · 06-27-2008, 01:06 PM

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

theking · 06-27-2008, 01:08 PM

Quote:

Originally Posted by woj

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 · 06-27-2008, 01:10 PM

Quote:

Originally Posted by theking

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

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

FightThisPatent · 06-27-2008, 01:49 PM

Quote:

Originally Posted by theking

...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 · 06-27-2008, 02:05 PM

define duplicate, duplicate of what?

StuartD · 06-27-2008, 02:09 PM

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 · 06-27-2008, 02:14 PM

Quote:

Originally Posted by 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.

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 · 06-27-2008, 03:43 PM

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 · 06-27-2008, 03:48 PM

dude

SELECT DISTINCT

theking · 06-27-2008, 03:51 PM

Quote:

Originally Posted by 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.

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 · 06-27-2008, 03:58 PM

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 · 06-27-2008, 04:00 PM

Quote:

Originally Posted by theking

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

Google is your friend...
http://www.google.com/search?q=%22remove%20duplicates%22phpmyadmin&sourc eid=mozilla2&ie=utf-8&oe=utf-8

brandonstills · 06-27-2008, 04:17 PM

Quote:

Originally Posted by theking

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 · 06-27-2008, 04:36 PM

Quote:

Originally Posted by mikesouth

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 · 06-27-2008, 04:42 PM

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

mikesouth · 06-27-2008, 08:17 PM

Quote:

Originally Posted by mrkris

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

06-26-2008, 11:08 PM	#1
theking Nice Kitty Industry Role: Join Date: Sep 2002 Location: The good old USA!!! Posts: 21,053	Is there a good SQL software that will ...scan and remove duplicates? __________________ When you're running down my country hoss...you're walking on the fighting side of me! FOR THE LYING LOWLIFE POSTING AS PATHFINDER...https://gfy.com/fucking-around-and-pr...athfinder.html

06-26-2008, 11:27 PM	#2
theking Nice Kitty Industry Role: Join Date: Sep 2002 Location: The good old USA!!! Posts: 21,053	Anyone...? __________________ When you're running down my country hoss...you're walking on the fighting side of me! FOR THE LYING LOWLIFE POSTING AS PATHFINDER...https://gfy.com/fucking-around-and-pr...athfinder.html

06-27-2008, 03:05 AM	#4
brandonstills Confirmed User Join Date: Dec 2007 Location: Chatsworth, CA Posts: 1,964	mysql is my favorite sql software, it allows you to do pretty much anything a RDBMS does. ask better questions, get better answers. hehe __________________ Brandon Stills Industry and programming veteran [email protected] \| skype: brandonstills \| ICQ #495-171-318

06-27-2008, 03:51 AM	#5
nnweb Confirmed User Industry Role: Join Date: Apr 2004 Location: OC Posts: 720	sql server 2005/2008 is the best out of the box sql server you can have. mysql is shit. __________________ ONLYFANS MANAGEMENT

06-27-2008, 11:50 AM	#7
tranza ICQ: 197-556-237 Join Date: Jun 2003 Location: BRASIL !!! Posts: 57,559	Here's a bump for you... __________________ I'm just a newbie.

06-27-2008, 02:56 AM	#3
Dvae Confirmed User Industry Role: Join Date: Feb 2005 Location: US Posts: 5,326	remove duplicates from what?

06-27-2008, 12:52 PM	#8
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	You don't need any additional software, just need a sql query to do it.... __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

06-27-2008, 01:06 PM	#11
Hell House Vic Pay to Cum Join Date: Aug 2004 Location: Nor San Diego Posts: 1,029	just search google for the right SQL query. No wait, YEAH I GOT A GREAT ONE, WANNA BUY IT FOR $100. j/k __________________ Contact Me - ICQ: 206851710 eMail vic (at) hellhousemedia (dot) com 'Satanism is like Capitalism for teens' - Ty HellHouse

06-27-2008, 02:05 PM	#15
brandonstills Confirmed User Join Date: Dec 2007 Location: Chatsworth, CA Posts: 1,964	define duplicate, duplicate of what? __________________ Brandon Stills Industry and programming veteran [email protected] \| skype: brandonstills \| ICQ #495-171-318

06-27-2008, 02:09 PM	#16
StuartD Sofa King Band Join Date: Jul 2002 Location: Outside the box Posts: 29,903	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. __________________ This is me on facebook This is me on twitter

06-27-2008, 03:43 PM	#18
mikesouth Confirmed User Industry Role: Join Date: Jun 2003 Location: My High Horse Posts: 6,334	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. __________________ Mike South It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.

06-27-2008, 03:48 PM	#19
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	dude SELECT DISTINCT __________________ 112.020.756

06-27-2008, 03:58 PM	#21
mikesouth Confirmed User Industry Role: Join Date: Jun 2003 Location: My High Horse Posts: 6,334	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. __________________ Mike South It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.

06-27-2008, 04:42 PM	#25
BradM Confirmed User Join Date: Dec 2003 Location: 1123,6536,5231 Posts: 3,397	You need to use psSql (PigshitSQL) to perform this function.