Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 10 Oct 2010, 21:07
maidos maidos is offline
 
Join Date: Jul 2006
sql help?

if anyone can help how to avoid dublicated primary key if the salary is different but the primary key=company name is the same?
or can anyone recommend me other site i can ask

an example is this Pulsen is the primary key


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #2  
Old 10 Oct 2010, 22:05
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
It seems like the solution would be to change the primary key (or maybe create a new table for the salary records), but I'm not a database expert so I can't tell you.

Last edited by kh99; 10 Oct 2010 at 22:11.
Reply With Quote
  #3  
Old 11 Oct 2010, 04:51
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
If it's a primary key it can't be duplicate, it must be unique- that is part of the definition of a 'primary key.'
__________________
-Joe
Former vBulletin.org Staff Member

(@BirdOPrey5) Former vb.org Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 23:43.

Layout Options | Width: Wide Color: