,, there is such a demand:
Two table, A table is the information table, table B is the history table, in addition to the fields in table A in table B, more than A "type" field;
Will the data in table A, I have to update to the table B, at the same time, the "type" field in table B automatically populated by A.a field corresponds to A type;
Don't know clearly stated the no, passing a great god can help me to look at with a trigger to realize ~
(baidu found that triggers a lot of more phyletic, grammar is great, but is basically all seem to check whether the insert/update/delete data format, don't know I can achieve I want, for a great god, thank,,)
CodePudding user response:
Will the data in table A, I have to update to the table B, at the same time, the "type" field in table B automatically populated by A.a field corresponds to A type;
In A field, A wanted to fill two fields to the table B?
CodePudding user response:
reference 1st floor wmxcn2000 response: I will send the data in table A, update to the table B, at the same time, the "type" field in table B automatically populated by A.a field corresponds to A type; CodePudding user response:
Give some test data, and then give you the desired results; CodePudding user response:
reference wmxcn2000 reply: 3/f give some test data, and then give you the desired results; CodePudding user response:
reference wmxcn2000 reply: 3/f give some test data, and then give you the desired results; CodePudding user response:
reference wmxcn2000 reply: 3/f give some test data, and then give you the desired results; 