華閱文章網mysql里面的if語句,到底哪里錯了
mysql 里面， 變量不需要加 @ 這個符號的呀 mysql> DELIMITER //mysql> CREATE PROCEDURE TestIfElse -> ( -> p_val INT -> ) -> BEGIN -> IF (p_val = 1) THEN -> SELECT '1' AS A; -> ELSEIF (p_val = 2) THEN -> SELECT '2' AS A; -> ELSE -> SELECT 'other' AS A; -> END IF; -> END//Query OK, 0 rows affected (0.05 sec)mysql> call TestIfElse(1); -> //+---+| A |+---+| 1 |+---+1 row in set (0.00 sec)Query OK, 0 rows affected (0.00 sec)mysql> call TestIfElse(2); -> //+---+| A |+---+| 2 |+---+1 row in set (0.00 sec)Query OK, 0 rows affected (0.00 sec)mysql> call TestIfElse(3); -> //+-------+| A |+-------+| other |+-------+1 row in set (0.00 sec)Query OK, 0 rows affected (0.00 sec)mysql>。
mysql條件語句
這個呀！有表結構么？如下不行就把真的錯誤信息發出來！或表結構！立刻搞定！--------------------------------------------------------AND ((*_sj >1288945672AND *aqingkuang IS NULL) or ( *_sj<1288945672AND *aqingkuang IS NULL ) or (*aqingkuang ！= '' )）-------------------------------------------------------第一這個看*_sj的類型，如果是數值型可以這么寫，如果不是就要 用'1288945672'。
第二 ，你那個AND都連接到一起了。--------------------------------------------------------AND ((*_sj >1288945672 AND *aqingkuang IS NULL) or ( *_sj<1288945672 AND *aqingkuang IS NULL ) or (*aqingkuang != '' ))=============================================================AND ((*_sj != 1288945672 AND *aqingkuang IS NULL) or (*aqingkuang ！= '' )）---------------------------------------------------------------表結構一放出來，把要求一說！立刻就搞定了！都是瞎猜呀！。
轉載請注明出處華閱文章網 » mysql條件if語句
