w10schools
Login Register
  • Home
  • Tutorials
    • HTML, CSS
      • HTML, HTML5
      • CSS, CSS3
    • XML
    • JavaScript, AJAX
    • PHP
    • Ruby on Rails
      • Ruby
      • Rails
    • ASP.NET
      • ASP
      • C# .NET
    • Java
      • JSP
    • Databases
      • MySQL
      • MSSQL Server
      • Oracle
    • Web Server
      • Windows
      • Linux
      • Apache
      • IIS
    • Design
      • Dreamweaver
      • Flash
      • Photoshop
      • Fireworks
      • CorelDRAW
      • Illustrator
  • References
    • HTML
      • Bootstrap
    • CSS
      • CSS Selectors
      • Sass
    • JavaScript
    • Mobile Apps
      • Cordova
    • Ruby on Rails
      • Ruby
      • Rails
    • PHP
      • Function
      • Language
      • CodeIgniter
      • Phalcon
      • PHPUnit
      • Symfony
      • Drupal
      • Yii
      • Laravel
    • Perl
      • Perl
    • Python
      • Python
      • Django
      • NumPy
      • Pandas
      • scikit-image
      • scikit-learn
      • Statsmodels
      • Matplotlib
    • Lua
      • Lua
    • C, C++
      • C
      • C++
    • Server
      • Docker
      • Apache HTTP Server
      • Nginx
    • Database
      • PostgreSQL
    • Big Data
      • TensorFlow
    • Game Development
      • Phaser
      • LÖVE
  • Articles
    • News
    • General
      • Website Promotion
      • Online Advertising
      • Make Money Online
    • Editorials
    • Interviews
    • Web Roundups
  • Resources
    • Design
      • Fonts
      • Graphics
      • Vectors
      • Templates
      • UI (User Interface)
      • Brushes
      • Patterns, Backgrounds
      • Textures
    • Web Development
      • HTML, CSS
      • XML
      • JavaScript, AJAX
      • Ruby on Rails
      • PHP
      • Java
      • .NET
      • Python
      • Perl
      • Flash
    • Mobile Application Development
      • Mobile Development Tools
      • Swift
    • Online Services
      • Online Storage
      • Web Hosting
  • Tools
    • Generators
Edit
In Place Editing Advanced Editing
  • References
  • PHP
  • Yii
  • db
  • Query

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
doc_Yii
2025-01-10 15:47:30
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 from() from() public method Sets the FROM part of the query. public $this from ( $tables )$tables string|array The table(s) to be selected from. Th
db\Query andWhere() andWhere() public method Adds an additional WHERE condition to the existing one. The new condition and the existing one will be joined using the
db\Query params() params() public method Sets the parameters to be bound to the query. See also addParams(). public $this params ( $params )$params array List o


Return to View
  • Facebook
  • Tweet
  • Digg it
  • Stumbleupon
  • Delicious
  • Plus Share

Designed by : w10schools

service@w10schools.com

Our Partners: aeeble – Providing content publishing and search solutions