Programming Help

Web Development



What's Here?

  • Members: 109,296
  • Replies: 413,799
  • Topics: 62,904
  • Snippets: 2,286
  • Tutorials: 607
  • Total Online: 1,213
  • Members: 49
  • Guests: 1,164

Who's Online?

Welcome to Dream.In.Code
Getting Help is Easy!

Join 109,296 Programmers for FREE! Ask your question and get quick answers from experts. There are 1,213 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now!



Too much Inconsistencies in Mysql

 
 Reply to this topicStart new topic

Too much Inconsistencies in Mysql
sattua
post 6 Aug, 2008 - 02:12 PM
Post #1


New D.I.C Head

*
Joined: 20 Mar, 2008
Posts: 25


My Contributions
I have a table in mysql with many Inconsistencies (for example :
Repeated primary keys); I have exported that table from excel with the command "load data.....",

thanks in advance..............
User is offlineProfile CardPM

Go to the top of the page


dineeshd
post 6 Aug, 2008 - 02:19 PM
Post #2


D.I.C Regular

Group Icon
Joined: 30 Jun, 2008
Posts: 407



Thanked 11 times

Dream Kudos: 575
My Contributions
What exactly you want?
User is offlineProfile CardPM

Go to the top of the page

sattua
post 6 Aug, 2008 - 09:47 PM
Post #3


New D.I.C Head

*
Joined: 20 Mar, 2008
Posts: 25


My Contributions
Remove the inconsistencies without eliminating data ...

thanks...
User is offlineProfile CardPM

Go to the top of the page

jjsaw5
post 8 Aug, 2008 - 12:21 PM
Post #4


D.I.C. Face

Group Icon
Joined: 4 Jan, 2008
Posts: 979



Thanked 5 times

Dream Kudos: 125
My Contributions
QUOTE(sattua @ 7 Aug, 2008 - 12:47 AM) *

Remove the inconsistencies without eliminating data ...

thanks...



How are we supposed to know what the inconsistencies of YOUR database are?

None of us have ever seen it so with out you telling us or us seeing it we are never going to be able to help you with this.
User is offlineProfile CardPM

Go to the top of the page

Trogdor
post 12 Aug, 2008 - 10:11 AM
Post #5


D.I.C Regular

Group Icon
Joined: 6 Oct, 2006
Posts: 451



Thanked 1 times

Dream Kudos: 125
My Contributions
The main problem is going to be the duplicates in the primary key (that will never be a real primary key this way).
I suggest adding a new autoincrement column that will function as the real primary key.
From there on you can identify the individual columns and use sql statements to clean up the mess.
User is online!Profile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 9/6/08 09:40AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month