DELIMITER: DELIMITER $$ ... $$ DELIMITER ; : Change statement terminator to define routines

CREATE PROCEDURE: CREATE PROCEDURE p() BEGIN SELECT NOW(); END; : Encapsulate reusable SQL logic

ALTER PROCEDURE: ALTER PROCEDURE p COMMENT 'Returns DT'; : Modify procedure metadata

DROP PROCEDURE: DROP PROCEDURE p; : Remove stored procedure

CREATE FUNCTION: CREATE FUNCTION f(x INT) RETURNS INT RETURN x*2; : Create user defined scalar function

DROP FUNCTION: DROP FUNCTION f; : Remove function

CREATE TRIGGER: CREATE TRIGGER trg BEFORE INSERT ON emp FOR EACH ROWSETNEW.created=NOW(); : Execute logic automatically on data change

DROP TRIGGER: DROP TRIGGER trg; : Remove trigger

CREATE EVENT: CREATE EVENT e_cleanup ON SCHEDULE EVERY 1 DAY DO DELETE FROM logs WHERE
created<DATE_SUB(NOW(),INTERVAL 30 DAY); : Schedule recurring job

ALTER EVENT DISABLE: ALTER EVENT e_cleanup DISABLE; : Enable or disable scheduled event

DROP EVENT: DROP EVENT e_cleanup; : Delete scheduled event

PREPARE / EXECUTE / DEALLOCATE: PREPARE stmt FROM 'SELECT ?+?'; EXECUTE stmt USING @a,@b;
DEALLOCATE PREPARE stmt; : Run dynamic SQL safely