Representing SQL constraints

Question

I have this table:

CREATE  TABLE `sold` (
`part_ID` INT(11) NOT NULL ,
`date` DATE NOT NULL ,
 PRIMARY KEY (`part_ID`, `date`) ,
 FOREIGN KEY (`part_ID` )
 REFERENCES `part` (`part_ID` );

This table represent parts sold each day, constraint says number of sales should be at least 25 and at most 100. How can I implement this constraint?

I think it should start with something like this:

CHECK ( NOT EXISTS ...

@AshReva enforcing this constraint: number of sales should be at least 25 and at most 100. — hamid
– hamid, Commented Mar 11, 2013 at 19:04

DevelopmentIsMyPassion · Accepted Answer · 2013-03-11 19:07:19Z

1

try below

CONSTRAINT chk_sales CHECK (columnName>=25 AND columnName <=100)

Also refer this link

answered Mar 11, 2013 at 19:07

DevelopmentIsMyPassion

3,6014 gold badges36 silver badges61 bronze badges

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

10 Comments

hamid Over a year ago

There is no column that holds number of sale!!

DevelopmentIsMyPassion Over a year ago

Then cant you have it? How will you add constraint then?

hamid Over a year ago

If i knew it, I wouldn't ask!

DevelopmentIsMyPassion Over a year ago

then can you add column as i said?

hamid Over a year ago

No. Table can not be altered.

|

Collectives™ on Stack Overflow

Representing SQL constraints

1 Answer 1

10 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related