Auto-create customer code
SQL
Medium
1 views
Problem Description
Customers(customer_id, code). On insert, if code is null, set it as 'C' + customer_id.
Output Format
Trigger created
Sample Test Case
Input:
Customers(customer_id, code)
Official Solution
CREATE TRIGGER trg_customer_code BEFORE INSERT ON Customers FOR EACH ROW SET NEW.code = COALESCE(NEW.code, CONCAT('C', NEW.customer_id));
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!