Login Register

db\Query union()

union() public method

Appends a SQL statement using UNION operator.

public $this union ( $sql, $all = false )
$sql	string\|yii\db\Query	The SQL statement to be appended using UNION
$all	boolean	TRUE if using UNION ALL and FALSE if using UNION
return	$this	The query object itself

Links:

http://www.yiiframework.com/doc-2.0/yii-db-query.html#union()-detail

doc_Yii

2016-10-30 16:59:05

Comments

Leave a Comment

Please login to continue.

Popular Articles

db\Query $union $union public property This is used to construct the UNION clause(s) in a SQL statement. Each array element is an array of the following structur

db_query db_query($query, array $args = array(), array $options = array()) Executes an arbitrary query string against the active database. Use this function f

db\Query each() each() public method Starts a batch query and retrieves data row by row. This method is similar to batch() except that in each iteration of the r

db\Query exists() exists() public method Returns a value indicating whether the query result contains any row of data. public boolean exists ( $db = null )$db yi

db\Query innerJoin() innerJoin() public method Appends an INNER JOIN part to the query. public $this innerJoin ( $table, $on = '', $params = [] )$table string|arra