DELIMITER $$
CREATE TRIGGER nameInUppercase
BEFORE INSERT ON city FOR EACH ROW
BEGIN
DECLARE dummy INT;
IF ISNULL(NEW.Name)<1 THEN
SET NEW.Name=FirstToUppercase(NEW.Name);
END IF;
END$$
DELIMITER ;
insert into city (Name) values ('adamo');
tusa@localhost:3306 [world]> Select Name from city where Name like "Ad%" Order by name limit 1;
+-------+
| Name |
+-------+
| Adamo |
+-------+
1 row in set (0.00 sec)

Latest conferences

We have 4277 guests and no members online