我写个触发器
create trigger updateTotal after insert on _meterhouryield for each row
select
if((select H00 from _totalhouryield where recordDate = 'new.recordDate') = null ,
(insert into _totalhouryield(recordDate, H00_Start, H00, H00_End) values('new.recordDate', new.H00_Start, new.H00, new.H00_End),
(update _totalhouryield SET H00_Start = H00_Start + new.H00_Start, H00 = H00 + new.H00, H00_End = H00_End + new.H00_End WHERE recordDate = 'new.recordDate'));
这个触发器无法创建
错误提示
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'into _totalhouryield(recordDate, H00_Start, H00, H00_End) values('new.recordDate' at line 3
这个是表结构
_meterHourYield表
| id | int(2)
| H00_Start | int(4)
| H00 | int(4)
| H00_End | int(4)
| recordDate | date
| name | varchar(1)
_totalHourYield表
| id | int(2)
| recordDate | date
| H00_Start | int(4)
| H00 | int(4)
| H00_End | int(4)