gis
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_full_name
Parameters
Name
Type
Mode
Definition
BEGIN IF NEW.typologie != OLD.typologie OR NEW.nom != OLD.nom THEN NEW.nom_complet:= CONCAT(NEW.typologie, ' ', NEW.nom); END IF; RETURN NEW; END;