mysql触发器在insert table_A时,在table_A字段name统计数量等于2时同时新增一条数据到tabl_B,否则不触发。
该如何修改?
```sql
//table_A统计name值:
SELECT COUNT(NAME)AS qty FROM
(SELECT
ID,NAME,ADDTIME,
(
CASE WHEN date_format(ADDTIME,'%H:%I:%S') BETWEEN '00:00:00' AND '08:30:59' THEN (DATE_FORMAT(DATE_SUB(ADDTIME,INTERVAL 1 DAY),'%Y-%m-%d N'))
WHEN date_format(ADDTIME,'%H:%I:%S') BETWEEN '20:30:59' AND '23:59:59' THEN (DATE_FORMAT(DATE_SUB(ADDTIME,INTERVAL 0 DAY),'%Y-%m-%d N'))
ELSE date_format(ADDTIME,'%Y-%m-%d D') END) AS NEWADDTIME
FROM table_A WHERE STATUS='2')TB
WHERE NAME='张三' AND (NEWADDTIME = date_format(now(),'%Y-%m-%d D') OR NEWADDTIME = date_format(now(),'%Y-%m-%d N')) //张三 为insert table_A时的值
//触发器 如何写条件,当table_A统计值大于2时,触发将
CREATE TRIGGER insert_sample
AFTER INSERT
ON table_A FOR EACH ROW
BEGIN
???//如何写条件;
insert into table_B(name,age,qty) values(new.name,new.age,统计数)
END