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());
Advertisements
Filed under: Uncategorized | Leave a comment »
