Error 20109 Primary Keys Are Not Unique
Contents |
7 Replies - 10737 Views - Last Post: 28 February 2011 - 01:30 AM Rate Topic: #1 nirvana.in.me New D.I.C Head Reputation: 0 Posts: 7 Joined: mysql duplicate entry for key primary 22-January 11 primary key not unique Posted 15 February 2011 - 08:52 AM mysql error 1062 duplicate entry for key primary im using the oracle database 10g express edition. can anybody help me make a primary key NOT unique. in mysql duplicate entry for key unique my schema, M:M, a i created a table with 2 primary keys and i need one of those attributes to be availably repeated. i did not declare the attributes unique, only
Mysql Allow Duplicate Primary Key
primary keys. however, when i add rows, the error says "ORA-02291: integrity constraint (MAJORMAJOR.SYS_C004104) violated - parent key not found". please help me make a primary key NOT unique. i just need an idea.PLEASE. Is This A Good Question/Topic? 0 Back to top MultiQuote Quote + Reply Replies To: primary key not unique #2 JackOfAllTrades Saucy! Reputation: 6243 Posts: 24,012 Joined: duplicate entry for key primary auto increment 23-August 08 Re: primary key not unique Posted 15 February 2011 - 08:58 AM A primary key is by its very definition unique. Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #3 nirvana.in.me New D.I.C Head Reputation: 0 Posts: 7 Joined: 22-January 11 Re: primary key not unique Posted 15 February 2011 - 09:04 AM so it's not possible? so i cannot repeat the values of these primary keys on the table? i thought that a primary key = not nullable, but may not be unique unique = nullable but must have unique values,different from the rest Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #4 baavgai Dreaming Coder Reputation: 6713 Posts: 14,119 Joined: 16-October 07 Re: primary key not unique Posted 15 February 2011 - 09:41 AM A primary key must be unique. Each table can only have one PK ( made up of one or more fields). If you want that combination of fields not to be unique, then it's inappropriate as a primary key. The PK is used to retrieve one, and only
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified duplicate entry '1' for key 'primary' mysql Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated
Mysql Copy Entry
SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail.
Mysql Duplicate Entry For Key Primary Auto_increment
By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by http://www.dreamincode.net/forums/topic/216267-primary-key-not-unique/ Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. MAS 90 (Sage) solutions Forum at Tek-Tips HomeForumsEnterprise ApplicationsERP and CRM Solution VendorsMAS 90 (Sage) solutions Forum Business Alerts sales order details thread637-1209844 Forum Search FAQs Links http://www.tek-tips.com/viewthread.cfm?qid=1209844 MVPs Business Alerts sales order details Business Alerts sales order details josiahjg (TechnicalUser) (OP) 27 Mar 06 12:06 Hello:We are trying to get business alerts to send a sales order email to the customer when a new SO is generated. Everything works fine, until we introduce the sales order lines (table SO2). We get an error:Error 20109: Primary keys are not unique. Duplicate key =I have tried linking tables every possible combination, but have not found the solution. Any ideas? Unique Fields has both SO1 and SO2 SalesOrderNumber (tried it with just one table as well).Thanks for any help or pointers in the right direction! Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Click Here to join