Yii2: Add INSERT INTO SELECT support

Created on 6 May 2015 · 7Comments · Source: yiisoft/yii2

Description of syntax can be found here.

Example (taken from here):

INSERT INTO Customers (CustomerName, Country)
SELECT SupplierName, Country FROM Suppliers;

Can't find it in core. QueryBuilder's insert method returns concatenated string with VALUES:

return 'INSERT INTO ' . $schema->quoteTableName($table)
    . ' (' . implode(', ', $names) . ') VALUES ('
    . implode(', ', $placeholders) . ')';

db enhancement

Source

arogachev

Most helpful comment

How if this feature added to batchInsert?

     * @param string $table the table that new rows will be inserted into.
     * @param array $columns the column names
     * @param array|Query $rows the rows to be batch inserted into the table
     * @return $this the command object itself
     */
    public function batchInsert($table, $columns, $rows)
    {

mdmunir on 19 Dec 2016

👍4

All 7 comments

Well, w3schools is not a good resource to refer to for a specific syntax.

Need to check the manuals of all Yii supported DBMS, here are some:

MySQL: https://dev.mysql.com/doc/refman/5.5/en/insert-select.html
Postgres: http://www.postgresql.org/docs/current/static/sql-insert.html
...

cebe on 6 May 2015

How if this feature added to batchInsert?

     * @param string $table the table that new rows will be inserted into.
     * @param array $columns the column names
     * @param array|Query $rows the rows to be batch inserted into the table
     * @return $this the command object itself
     */
    public function batchInsert($table, $columns, $rows)
    {

mdmunir on 19 Dec 2016

👍4

if (is_array($info)) {..........}
if (is_array($result) && isset($result[0])) {........}


if (isset($info[0])) {..........}
if (isset($result[0])) {........}