mysql-Multi-Conditional splicing statement

BEGINSET @baseStr="SELECT *  fromTbnameWHERE 1=1 ";SET @_where="";IF 1=1  Then 　　 SET @_where=CONCAT (@_where," andSourcedomain=\ "Www.baidu.com\" ");END IF;IF 2=2  Then  　　 SET @_where=CONCAT (@_where," andUserid=4444");END IF;SET @sentence =CONCAT (@baseStr,@_where) ;--The connection string generates the SQL statement to executePreparestmt from @sentence;--pre-programmed release. The name of the "stmt" pre-release variable,Executestmt--Execute SQL statementdeallocate Preparestmt--Freeing ResourcesEND

2.out Value Assignment

SET @_rowcount=0;--variablesSET @_count =CONCAT ("SELECT COUNT(*) into @_rowcount",@baseStr,@_where);Preparestmt from @_count;Executestmt;deallocate Preparestmt;SET_pagecount=@_rowcount;

mysql-Multi-Conditional splicing statement