Avatar of toymachiner62
Flag for United States of America

asked on 

Why is this constraint not enforced

Im not sure why this constraint isn't enforced. it's supposed to be enforced for the table payment attribute payment type. The table schema is

payment(orderId, orderNum, paymentType, totalCost)
alter table payment
add constraint paymentType
check(value in ('C', 'D', '$'))

Open in new window

MySQL Server

Avatar of undefined
Last Comment
Roger Baklund

8/22/2022 - Mon