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 ...
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 ...
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 ...
on the Internet, many methods of judging https are stereotyped. mainly judges reference links from $_ SERVER to https: blog.csdn.net river13.https: codeshelper.com q 10.. but now nginx has done reverse proxy $_ SERVER without the following p...
Does the constructor of javascript need not be written in the entry function used to be written in window.onload = function () {}, but today I suddenly found that I forgot to write the entry function at the beginning (the constructor is written in fro...
help explain why the output is 333 and aaa function superClass () { this.c =333; this.d = bbb ; } function subClass () { this.c =222; superClass.call(this); this.d = aaa ; console.log(this.c); 333 console.log(this.d); aaa } subClass (); ...
Why is the data under the user field in the query result incorrect? User is supposed to be the contents of the user table, but the result is the contents of the blog table. Why? I ve been doing it all day and I don t know what s going on. Can you tak...
Today, I checked and learned some of the application scenarios of reduce api on the Internet, and also followed the implementation of the code in the Google console. I read an article requirements: add () (1: add () (2) (3 br 4) (7page8pint 9) () final ...