How to add multiple column Unique key in mySQL

Question

I want to add the unique constarint I am using the following query but it gives me an error of SQL syntax

ALTER TABLE user_device ADD CONSTRAINT UKnfrn6f2pu3tqcwhqen0d6cq7u (owner,push_notification_id);

where is the mistake :| it highlighted the mistake in push_notification_id

Sagar Gangwal · Accepted Answer · 2017-06-07 09:51:45Z

2

ALTER TABLE user_device ADD CONSTRAINT UKnfrn6f2pu3tqcwhqen0d6cq7u UNIQUE KEY  (owner,push_notification_id);

Try above code. You didn't mention which type of key you want to make on that combination of column. So i had mention that using UNIQUE KEY keyword.

Hope this will helps you.

answered Jun 7, 2017 at 9:51

Sagar Gangwal

8,1303 gold badges28 silver badges45 bronze badges

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

Comments

Mayank Pandeyz · Accepted Answer · 2017-06-07 10:00:00Z

0

Do Like this.

ALTER TABLE user_device ADD unique index UKnfrn6f2pu3tqcwhqen0d6cq7u (owner,push_notification_id);

edited Jun 7, 2017 at 10:00

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

answered Jun 7, 2017 at 9:51

Shuddh

1,9703 gold badges19 silver badges30 bronze badges

Collectives™ on Stack Overflow

How to add multiple column Unique key in mySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related