本文探讨了MySQL中查询语句中'and'与在编程逻辑判断中'&&'的区别，'and'主要用于WHERE子句连接多个条件，而'&&'常用于编程语言的条件判断表达式。
CREATE FUNCTION `get_times_weeek` (
last_accting_date DATETIME,
nursePerformTime VARCHAR (50)
) RETURNS INT (11) COMMENT '计算以周为单位的计费次数'
BEGIN
DECLARE return_val INT DEFAULT 0 ;
DECLARE flag BOOLEAN DEFAULT FALSE ;
DECLARE weekNo INT ;
DECLARE s_index INT ;
IF last_accting_date IS NOT NULL && DATE_FORMAT(NOW(), '%Y-%m-%d') = DATE_FORMAT(last_accting_date, '%Y-%m-%d')
THEN SET return_val = 0 ;
ELSE
SELECT
DAYOFWEEK(NOW()) INTO weekNo ;
last_accting_date DATETIME,
nursePerformTime VARCHAR (50)
) RETURNS INT (11) COMMENT '计算以周为单位的计费次数'
BEGIN
DECLARE return_val INT DEFAULT 0 ;
DECLARE flag BOOLEAN DEFAULT FALSE ;
DECLARE weekNo INT ;
DECLARE s_index INT ;
IF last_accting_date IS NOT NULL && DATE_FORMAT(NOW(), '%Y-%m-%d') = DATE_FORMAT(last_accting_date, '%Y-%m-%d')
THEN SET return_val = 0 ;
ELSE
SELECT
DAYOFWEEK(NOW()) INTO weekNo ;
订阅专栏 解锁全文
扫一扫
2232
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
