ERROR 1170 (42000): BLOB/TEXT column ‘field_name’ used in key specification without a key length.

Use Varchar(some length under 257) and this will allow it to be a key field.

—

DROP TRIGGER Syntax

DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name

—

Good PDF on creating MySql Triggers http://www.paragon-cs.com/mag/issue6.pdf

CREATE TRIGGER emplog_insert AFTER INSERT ON emp
FOR EACH ROW
INSERT INTO emplog VALUES (NEW.id, NEW.lastname, NEW.firstname, NEW.gender, NEW.dob,
NEW.marital, NEW.SSN, ‘I’, NULL, USER());