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 [...]
Filed under: Uncategorized | Leave a Comment »