Ad
SQL (Custom) Unique Constraint For A Set Of Rows
How to create a ( may be custom) unique constraint for a particular no.of rows.
I have table data as below
I want my itemFK column to be Unique for same productionsessionKey value. i.e for all yellow (101) itemFK should be Unique and for all blue (102) itemFK should be unique. Else they can be duplicate.
Ad
Answer
Add a unique constraint on a tupple for those 2 columns
F.e.
ALTER TABLE your_table
ADD CONSTRAINT UC_Your_Table_ProdSession_Item UNIQUE (productionsessionKey, itemFK);
Ad
source: stackoverflow.com
Related Questions
- → I can't do a foreign key, constraint error
- → How to implement DbDongle::convertTimestamps as workaround of invalid timestamps with MySql strict
- → MySQL error "Foreign key constraint is incorrectly formed"
- → Eloquent Multitable query
- → "Laravel 5.1" add user and project with userId
- → Database backup with custom code in laravel 5 and get the data upto 10 rows from per table in database
- → Laravel 5.1 QueryException when trying to delete a project
- → Using Array in '->where()' for Laravel Query Building
- → Chaining "Count of Columns" of a Method to Single Query Builder
- → Laravel Eloquent Joining Strange query
- → convert time using mysql laravel 5
- → How to update a column after an expiration date in MySQL?
- → Foreign key constraint fails on existing key
Ad