current position:Home>Trigger implementation inserts some fields of one table into another table
Trigger implementation inserts some fields of one table into another table
2022-02-02 11:57:00 【CSDN Q & A】
surface A There are fields id,name,age,class,score
surface B There are fields id,name,age
How to create triggers to make tables A When a record is inserted , Insert three of these fields into the table at the same time B in
Refer to the answer 1:
Define post insert trigger .
DROP TRIGGER IF EXISTS `ins_info`; create trigger ins_info after insert on nhfxelect for each row begin if HOUR(new.RecordTime)='20' then insert into nhfxbyhour (UnitDepName, UnitDepCode, ElectCost, TimeJG, RecordTime) values( ' School of Statistics ', '1', new.USERKWH, '20', new.RecordTime); end if; end;
Refer to the answer 2:
copyright notice
author[CSDN Q & A],Please bring the original link to reprint, thank you.
https://en.primo.wiki/2022/02/202202021156583883.html
The sidebar is recommended
- How to read text from TXT document, write it into excel and run it in reverse?
- Calculation of joint torque of detal manipulator
- Give a string representing the date and ask what day of the year it is
- [Vue] setting @ media to query font size is not effective
- How to use the ecarts national map to the city? I CV changed other people's codes and key values. Now this is the case
- Hbuilderx
- Design database (agricultural products sales database, clothing sales database and stamen sales database)
- Let's see if the course sequence of distributed architect is correct
- What's the matter with me? Please answer
- Link failure of distributed task scheduling
guess what you like
-
The bean tag calls auto assembly and has been given a parameterless construction Setget, why is class still null
-
"The column vectors of a matrix whose determinant is equal to zero may not be linearly correlated"
-
PTA 7-1 string sorting (10 points)
-
Output the full arrangement of all 1 2 3 4 5 in dictionary order
-
How to create SQL trigger
-
Stm32tftlcd displays Chinese character scrolling
-
The format of the command in the CMD window is unclear
-
What does the class name in the class mean? It's not a variable or a member function
-
Seems to have started a program called [com,.] Process. But failed to stop it, which is likely to cause a memory leak. Stack trace for Thread:
-
Object oriented programming questions
Random recommended
- What are the impossible out of stack sequences when a certain in stack sequence is CADB?
- How to do this!
- Given a matrix of N x n, find the matrix after 90 degrees of rotation
- Mac Pro M1 chip 13 inch how to delete non store software?
- Is there any student to answer the single linked list in the data structure
- On the problem of incomplete display of Vue multi selection box data
- About the problem of incomplete data acquisition in Vue's select multiple selection box
- 360 fast travel assistant how to delete
- What are the experimental equipment and requirements of C language experiment report
- Why do the left and right shifts of bit operations correspond to decimal multiplication and division
- C language will not be painful, seek solutions