21,886
社区成员
发帖
与我相关
我的任务
分享
CREATE
/*[ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
[DEFINER = { user | CURRENT_USER }]
[SQL SECURITY { DEFINER | INVOKER }]*/
VIEW `dbbase`.`viewname`
AS
(SELECT * FROM ...)
create trigger updateDate
after insert on A
for each row
begin
update B
set `总和字段` = (select count(`数据`) from A where F_Month='七月');
end