select @klx_num := kaleixing from poll_code WHERE id = LAST_INSERT_ID();
SElecT CASE @klx_num
WHEN 1 THEN @mytime = date_add(now(), interval 1 DAY )
WHEN 7 THEN @mytime = date_add(now(), interval 1 WEEK )
WHEN 30 THEN @mytime = date_add(now(), interval 1 MONTH )
WHEN 90 THEN @mytime = date_add(now(), interval 1 QUARTER )
WHEN 365 THEN @mytime = date_add(now(), interval 1 YEAR )
end;
UPDATE poll_code SET enddate = @mytime WHERE id = LAST_INSERT_ID();
//-----------------------------------------------------------------------------
上面是我写的代码,下面是我创建的触发器思路,求大神帮忙更改一下,或者写一段新的代码//-----------------------------------------------------------------------------有两张表,poll_code和guodubiao
在guodubiao创建一个触发器,
当guodubiao有数据插入的时候,读取poll_code表中新插入的数据中kaleixing的数值,做判断求出时间,
并将求出的时间更新到poll_code表内的enddate字段中
set @mytime =
CASE @klx_num
WHEN 1 THEN date_add(now(), interval 1 DAY )
WHEN 7 THEN date_add(now(), interval 1 WEEK )
WHEN 30 THEN date_add(now(), interval 1 MONTH )
WHEN 90 THEN date_add(now(), interval 1 QUARTER )
WHEN 365 THEN date_add(now(), interval 1 YEAR )
end;
UPDATE poll_code SET enddate = @mytime WHERE id = LAST_INSERT_ID();