MySQL Forums
Forum List  »  Newbie

Primary Index
Posted by: Jeremy Schubert
Date: July 03, 2010 09:15AM

I have created a database that contains the following fields:
Below is a sample of the CSV file I'm importing.
I currently have the UPC column marked as my primary index. What would be the pros and cons of inserting an auto increment column and making that the indes?
Thx, Jeremy

0000000819534;"16 oz (454g)";"Trader Joe's Organic Crunchy Peanut Butter";;0;Y;1
0000000822701;"20 oz.";"Trader joe's Soy & Flax Clusters";;0;N;0
0000000840620;5'x150';"Concrete reinforce mesh";;0;N;0
0000000841122;10.8oz;"Trader Joes Milk Chocolate coated Pistachios";;0;Y;4
0000000845809;"32 oz (907g)";"Trader Joe's Multigrain Baking & Pancake Mix";;0;Y;2
0000000854832;"3.4 oz";"Trader Joe's Sesame Rice Crackers (Savory Thins)";;0;N;0
0000000857963;;"DCO CLASSIC PLN HORSE SHOES";;0;N;0
0000000863506;"9oz. (255g)";"Trader Joes Organic Mini Peanut Butter Sandwich Crackers";;0;N;0
0000000870429;"14.1 OZ (400 g)";"Trader Joe's White Beans with Vegetables";;0;N;0
0000000870634;"32 fl oz (1 qt) 945 mL";"Trader Joe's Organic Low Sodium Chicken Broth";;0;N;0

Options: ReplyQuote

Written By
Primary Index
July 03, 2010 09:15AM
July 03, 2010 09:42AM
July 03, 2010 10:28AM
July 03, 2010 11:59AM
July 04, 2010 10:49AM
July 04, 2010 10:53AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.