Newbie Duplicate Data Question
Hi. I just started transitioning from Front End Development to Full Stack.
I currently have a PHP script writing data to MySQL. I have 2 columns that cannot
have duplicate field/cell values per record/row:
`merchant_order_id` and `amazon_order_id`
Would indexing these 2 columns be the only way to have MySQL prevent duplicate values?
Is there another way? Is indexing even the best solution for preventing duplicate cell/field values in the same column?
I am about to spend a bunch of hours reading the MySQL & PHPMyAdmin docs so I might figure this out on my own but any help or advice would be greatly appreciated.
Thanks.
Subject
Written By
Posted
Newbie Duplicate Data Question
February 20, 2018 06:10PM
February 20, 2018 07:07PM
February 21, 2018 06:10AM
February 21, 2018 01:31PM
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.