CREATE TABLE `tbl_workplan` (
`intPlanID` int(11) NOT NULL auto_increment,
`strContent` text COMMENT '划计内容',
`intType` tinyint(4) default NULL COMMENT '0日计划,1日总结,2周计划,3周总结',
`dtCreateTime` timestamp NULL default NULL COMMENT '建时间创',
`dtUpdateTime` timestamp NULL default NULL COMMENT '最后更新时间',
`intUserID` int(11) default NULL COMMENT '户用ID',
`strIPAddress` varchar(30) default NULL COMMENT 'ip地址',
PRIMARY KEY (`intPlanID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
DELIMITER ;;
CREATE PROCEDURE `saveplan`(in userid int,in ipaddress varchar(30),in content text,in inttype tinyint(4))
begin
declare quantity int default 0;
select count(*) into quantity from tbl_workplan where intUserID=userid and date(dtCreateTime)=curdate() and intType=inttype;
if quantity=0 then
insert into tbl_workplan (intPlanID,strContent,intType,dtCreateTime,dtUpdateTime,intUserID,strIPAddress) values (null,content,inttype,now(),now(),userid,ipaddress);
end if;
end;;
DELIMITER ;
第一次调call saveplan('1','192.168.1.2','aksakbs','0')插入了数据;
再调一次call saveplan('1','192.168.1.2','aksakbs','1');就写入不了数据了,为什么?
这个一直为“true”