×
Night mode
Sign up
Login
Create TRIGGER before INSERT "to_upper"
Creates TRIGGER 
to_upper
that will run before inserting student into students table and makes 
first_name
UPPER CASE
DROP TRIGGER IF EXISTS to_upper;

CREATE TRIGGER to_upper
BEFORE INSERT ON students
FOR EACH ROW
    SET NEW.first_name = UPPER(NEW.first_name);
by Valeri Tandilashvili
4 years ago
MySQL
TRIGGERS
Full MySQL Course for Beginners
1
Pro tip: use ```triple backticks around text``` to write in code fences