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：
author[CSDN Q & A],Please bring the original link to reprint, thank you.
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
- 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
- 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