Preventing duplicate data in MySQL

Question

Say I have a table with columns mobile phone models and their ram/rom. The table can have two rows with same models but with different ram/rom, different models with same ram/rom but not same models with same ram/rom. Do you know about any special primary key or something to do this?

Thanks for any help.

Tim Biegeleisen · Accepted Answer · 2020-12-27 03:11:33Z

1

You could add a unique index covering both the phone model and memory storage columns, e.g.

ALTER TABLE yourTable ADD UNIQUE u_idx (model, memory);

answered Dec 27, 2020 at 3:11

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Devesh Agarwal Over a year ago

Thanks for your reply Tim Biegeleisen i will try it.

Collectives™ on Stack Overflow

Preventing duplicate data in MySQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related