Allow some combination in sql

Asked Apr 26 '22 at 23:26

Active Apr 27 '22 at 00:22

Viewed 32 times

I am working on one major issue where I have to add some constraint or need a way by which only this combination is allowed.

Table User (Strind id, String status)

only single id is allowed with value status 1. How can i write the constraint or how to solve this issue. mysql database Thanks, Hasnain

edited Apr 27 '22 at 00:22

asked Apr 26 '22 at 23:26

Hasnain Ali Bohra

3

You should add which RDBMS you're working with~ – BeRT2me Apr 26 '22 at 23:31
Maybe [this](https://stackoverflow.com/questions/866061/conditional-unique-constraint) will work with your requirements? – mtdot Apr 27 '22 at 02:16

0 Answers0