Question

mysql存储过程中的问题！

DECLARE _ids CURSOR FOR SELECT LOG_ID FROM core_log WHERE WEBSITE_ID= 2 AND DATEDIFF(d,LOG_TIME,‘2013-04-12’)>0;

Answer 1

DECLARE _ids CURSOR FOR SELECT LOG_ID FROM core_log WHERE WEBSITE_ID= 2 AND LOG_TIME>‘2013-04-12’;