Maintain stock on order item insert

Maintain stock on order item insert

Easy SQL Triggers 17 views
Explanation Complexity

Problem Statement

When a new OrderItems row is inserted, decrement Inventory.qty.

Input Format

SQL DDL

Output Format

Trigger created

Example

OrderItems, Inventory
Trigger created

Constraints

Check qty >= requested elsewhere

Input / Output Format

Input Format
SQL DDL
Output Format
Trigger created
Constraints
Check qty >= requested elsewhere

Examples

Input:
OrderItems, Inventory
Output:
Trigger created

Example Solution (Public)

SQL 
CREATE TRIGGER trg_orderitems_decrement AFTER INSERT ON OrderItems FOR EACH ROW UPDATE Inventory SET qty = qty - NEW.qty WHERE product_id = NEW.product_id;

Official Solution Code

CREATE TRIGGER trg_orderitems_decrement AFTER INSERT ON OrderItems FOR EACH ROW UPDATE Inventory SET qty = qty - NEW.qty WHERE product_id = NEW.product_id;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.