Auto-create customer code

Auto-create customer code

Medium SQL Triggers 14 views
Explanation Complexity

Problem Statement

Customers(customer_id, code). On insert, if code is null, set it as 'C' + customer_id.

Input Format

SQL DDL

Output Format

Trigger created

Example

Customers(customer_id, code)
Trigger created

Constraints

Use CONCAT

Input / Output Format

Input Format
SQL DDL
Output Format
Trigger created
Constraints
Use CONCAT

Examples

Input:
Customers(customer_id, code)
Output:
Trigger created

Example Solution (Public)

SQL 
CREATE TRIGGER trg_customer_code BEFORE INSERT ON Customers FOR EACH ROW SET NEW.code = COALESCE(NEW.code, CONCAT('C', NEW.customer_id));

Official Solution Code

CREATE TRIGGER trg_customer_code BEFORE INSERT ON Customers FOR EACH ROW SET NEW.code = COALESCE(NEW.code, CONCAT('C', NEW.customer_id));
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.