I made an input box and did text-transform: uppercase but when the data is inserted in phpMyAdmin, it is not uppercase unless I manually capitalize each letter. I wanted to make a MySQL trigger where if data is inserted the word is uppercase automatically in phpMyAdmin.
MySQL trigger that capitalize all letter
Viewed 569
1 Answers
CREATE TRIGGER trigger_name
BEFORE INSERT
ON table_name
FOR EACH ROW
SET NEW.column_name = UPPER(NEW.column_name);
CREATE TRIGGER trigger_name
BEFORE UPDATE
ON table_name
FOR EACH ROW
SET NEW.column_name = UPPER(NEW.column_name);
Related