Create a Insert… Select statement in Laravel

by

There is no way of doing this in one query (unless you are on Laravel 5.7), however I came across the same issue and wanted to make sure I can keep using a certain select I build with the QueryBuilder.

So what you could do, to keep things half what clean and to reuse functionality which has built a select statement before, is this:

/**
 * Wherever your Select may come from
 **/
$select = User::where(...)
                  ->where(...)
                  ->whereIn(...)
                  ->select(array('email','moneyOwing'));
/**
 * get the binding parameters
 **/ 
$bindings = $select->getBindings();
/**
 * now go down to the "Network Layer"
 * and do a hard coded select
 */
 $insertQuery = 'INSERT into user_debt_collection (email,dinero) '
                . $select->toSql();
    
 \DB::insert($insertQuery, $bindings);

UPDATE Laravel 5.7

As of Laravel 5.7.17 you can use ->insertUsing(). See here for details. Thank you @Soulriser for pointing this out.

So above query would look like this:

DB::table('user_debt_collection')->insertUsing(['email','dinero'], $select);

More Related Contents:

  1. How do I store a custom user selected CSS template style (like wordpress visual editor)? [closed]
  2. Laravel – only a zero is saved to the database
  3. Laravel one to many relation with a one to one relation
  4. How to use multiple databases in Laravel
  5. Laravel 5 PDOException Could Not Find Driver
  6. Laravel migration: unique key is too long, even if specified
  7. Laravel: PDOException: could not find driver
  8. Laravel Eloquent select all rows with max created_at
  9. Laravel: connect to databases dynamically
  10. Laravel OrderBy relationship count
  11. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  12. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  13. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  14. Laravel Migration table already exists, but I want to add new not the older
  15. “No such file or directory” or “No such host is known” when running migrations
  16. Laravel $q->where() between dates
  17. belongsToMany relationship in Laravel across multiple databases
  18. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  19. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  20. Laravel Eloquent get results grouped by days
  21. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  22. Change name of Laravel’s created_at and updated_at
  23. How do I get database column names in Laravel?
  24. How to get MySql 8 to run with laravel? [duplicate]
  25. Eloquent many-to-many-to-many – how to load distant relation easily
  26. PHP Laravel: No connection could be made because the target machine actively refused it
  27. How to create a database-driven multi-level navigation menu using Laravel
  28. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  29. Check if laravel model got saved or query got executed
  30. find in set in laravel ? example

Leave a Comment