php - TRIGGER CREATED successfully , but no triggers in information_schema TRIGGERS table -
Hi, I'm trying to use the trigger, my MySQL version is 5.5.8
This is when I'm creating a trigger, PHPMadmin says it has been created successfully,
This is my trigger It says that But when I select from Why this is happening, please help me, thanks in advance. Check it out .. It will help you ... and make sure the query is of the same type as shown in the image change ": =" to "=" / P>
DELIMITER $$ INSTORE before the 'triggers' check_pipil_apaign' for every line, if it starts at `pupil_data`, CHAR_LENGTH (new.Defferth) & lt; 4 THEN SIGNAL SQLSTATE '12345' SET MESSAGE_TEXT: = 'Check interruption on pupil_data. Debtoffbirth failed '; end if; END $$ DELIMITER;
your SQL query has been executed successfully DELIMITER create $$ trigger 'check_pipil' before leaving 'for each line' Before signing the pupil_data`, CHAR_LENGTH (New. Datfurth) & lt; 4 THEN signal SQLSTATE '12345' SET MESSAGE_TEXT: = 'Check interruption on pupil_data. Debt failure failed '; end if ;
info_schema.triggers * MySQL returned an empty result set (i.e. zero lines). (Query took 0.0843 seconds) SELECT * info_schema.triggers LIMIT from 0, 30
Comments
Post a Comment