MySQL Forums
Forum List  »  Newbie

Newbie Duplicate Data Question
Posted by: Julius Alvarado
Date: February 20, 2018 06:10PM

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.

Options: ReplyQuote


Subject
Written By
Posted
Newbie Duplicate Data Question
February 20, 2018 06:10PM


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.