Stop INSERT and UPDATE if Products.price <= 0. Write triggers that raise an error when invalid price comes.

SQL Program to Prevent negative price with Explanation

Prevent negative price

Easy SQL Triggers 16 views

Explanation Complexity

Problem Statement

Stop INSERT and UPDATE if Products.price

Input Format

SQL DDL

Output Format

Trigger created

Example

Input

Products(price)

Output

Trigger created

Constraints

MySQL-style SIGNAL for error

Input / Output Format

Input Format

SQL DDL

Output Format

Trigger created

Constraints

MySQL-style SIGNAL for error

Examples

Input:

Products(price)

Output:

Trigger created

Example Solution (Public)

SQL

CREATE TRIGGER trg_products_price_ins BEFORE INSERT ON Products FOR EACH ROW BEGIN IF NEW.price <= 0 THEN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT='Invalid price'; END IF; END; CREATE TRIGGER trg_products_price_upd BEFORE UPDATE ON Products FOR EACH ROW BEGIN IF NEW.price <= 0 THEN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT='Invalid price'; END IF; END;

Official Solution Code

CREATE TRIGGER trg_products_price_ins BEFORE INSERT ON Products FOR EACH ROW BEGIN IF NEW.price <= 0 THEN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT='Invalid price'; END IF; END; CREATE TRIGGER trg_products_price_upd BEFORE UPDATE ON Products FOR EACH ROW BEGIN IF NEW.price <= 0 THEN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT='Invalid price'; END IF; END;

Please login to submit solutions.

Editor

Input

Expected Output

Compile Output

Error

Output

Please login to submit solutions.