Reject invalid orders with CHECK

CREATE DATABASE cookbook_check;
CREATE TABLE cookbook_check.orders(
  id INT PRIMARY KEY, amount INT,
  CONSTRAINT positive_amount CHECK(amount > 0)
);
INSERT INTO cookbook_check.orders VALUES(1,10);
INSERT IGNORE INTO cookbook_check.orders VALUES(2,-5);
SELECT COUNT(*) AS accepted_rows FROM cookbook_check.orders;
SHOW CREATE TABLE cookbook_check.orders;
DROP DATABASE cookbook_check;

Expect accepted_rows=1 and positive_amount in the table definition. An ordinary INSERT violating the constraint errors; INSERT IGNORE skips the row. Add NOT NULL if the business rule rejects null amounts, since CHECK does not treat unknown as a violation. See the source constraint test.