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

  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;   

It says that

  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 ;   

But when I select from

  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   

Why this is happening, please help me, thanks in advance.

IMAGE

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>

Comments

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

c# - Add Image in a stackpanel based on textbox input -

java - Reaching JTextField in a DocumentListener -