默认创建存储过程的语句:
DELIMITER $$
CREATE
/*[DEFINER = { user | CURRENT_USER }]*/
PROCEDURE `recycle`.`dpdatestatus`()
/*LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
| COMMENT 'string'*/
BEGIN
update dealinfo set dealstateid=4 where CURRENT_TIMESTAMP()=endtime and dealstateid=2;
END$$
DELIMITER ;
奇葩;百度都说//可以,但是傲娇的sqlyog就是不可以,我也是醉了