none
Creating TRIGGERS RRS feed

  • Question

  • Hi,

        I want to create a trigger which would drop a database when a row of another database is deleted. I am using MySQL database. Currently i am using the trigger as given below. But its not working.

    DELIMITER $$
    CREATE TRIGGER deletePData
    AFTER DELETE ON `ProjectDB`.`Project_Name_Table`
    FOR EACH ROW BEGIN
      DELETE DATABASE OLD.Project_Name_Column;
    END;
    $$


    plz someone give me a solution.

    Solution for SQL Server will also be OK


    Thanks & Regards
    Akhil.N.P
    Akhil.N.P
    Tuesday, October 14, 2008 5:10 AM

Answers

All replies