 |  |  |  |  |  |  |  |
Issues With Inserting Item
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Jul 2005
Posts: 55
Reputation: 
Solved Threads: 1
Junior Poster in Training
Before I continue, quick explanation:
product table
pid (primary key), pdesc (Product discussion), and pquant (quantity of product).
I then link it to sub_category which determines if it is where it falls (AKA SODIMM or DIMM).
Now, I have duplicate product descriptions (160GB HD, for example.) We have 2.5 inch versions and 3.5 inch version, in which case we have different quantities of each. I didn't set the pdesc as a primary key, so theoretically since each product is described by the pid, i should be able to have duplicate pdesc but it isn't working.
Any ideas?
product table
pid (primary key), pdesc (Product discussion), and pquant (quantity of product).
I then link it to sub_category which determines if it is where it falls (AKA SODIMM or DIMM).
Now, I have duplicate product descriptions (160GB HD, for example.) We have 2.5 inch versions and 3.5 inch version, in which case we have different quantities of each. I didn't set the pdesc as a primary key, so theoretically since each product is described by the pid, i should be able to have duplicate pdesc but it isn't working.
Any ideas?
•
•
Join Date: Apr 2008
Posts: 296
Reputation:
Solved Threads: 42
Posting Whiz in Training
Hello
Because both products differ in an important property they must have different part numbers. So you are able to manage different quantities, deliverers, prices, taxes etc.
You may put them into same category, for example "hard disks" to get a list of all hard disks if necessary.
krs,
tesu
Because both products differ in an important property they must have different part numbers. So you are able to manage different quantities, deliverers, prices, taxes etc.
You may put them into same category, for example "hard disks" to get a list of all hard disks if necessary.
krs,
tesu
Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.
|
Similar Threads
Other Threads in the MySQL Forum
- Previous Thread: Mysql IsNull check
- Next Thread: Problem with using DECODE
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux maintenance managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql syntax techsupport thunderbird transparency virtualization
