trigger - Related information

  • Oracle trigger executes Times ORA-04091 and ORA-00060 errors

    scenario: when the business level deletes (physically deletes) a piece of data from Table A, the data is inserted into Table B. set up a trigger on table A CREATE OR REPLACE TRIGGER cmsinfo AFTER delete ON tablea for each row BEGIN IF DELETING THEN ...

    Sep.16,2021
  • Jdbc trigger error in creating MySQL?

    as shown below, I use jdbc to create a MySQL trigger, which is successfully created in navicat. After the sql2 is output, it runs successfully in navicat. However, when the program runs, it will prompt that there is a syntax error in the statement that ...

    Feb.28,2021
  • Triggers create views in the database

    in sql server database, an insert trigger is set for a table, and a new view is created in the trigger. How to design and write statements? Thank you ...

  • MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
    MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1c25334-33769.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
    MySQL Errno : 1021
    Message : Disk full (/tmp/#sql-temptable-64f5-1c25334-33769.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
    Need Help?