Two database connection in one query in Laravel

Question

I need to use INSERT INTO...SELECT but using two different database in Laravel. Database A is a local database. Database B is a remote database.

I need something like this :

INSERT INTO local.table1
SELECT * 
FROM remote.table1
ON DUPLICATE KEY UPDATE col1=col1

Is there any way I could achieve this in laravel? Thanks!

u want to select rows from local and insert rows into remote database..am i right? — Jignesh Joisar
– Jignesh Joisar, Commented Feb 4, 2019 at 7:15
no, I want to select rows from remote and insert into local database @JigneshJoisar — user7414328
– user7414328, Commented Feb 4, 2019 at 7:20

Mihir Bhende · Accepted Answer · 2019-02-04 07:22:18Z

4

You can have multiple database connections in Laravel. Follow this post.

Then to utilise it :

<?php 

$selectQuery = \DB::connection('remote')
    ->table('table1')
    ->select('column1','column2','column3');

\DB::connection('local')->insert('INSERT INTO table1 (column1, column2, column3) ' . $selectQuery->toSql(), $selectQuery->getBindings());

answered Feb 4, 2019 at 7:22

Mihir Bhende

9,0952 gold badges33 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user7414328 Over a year ago

This doesn't work. It seems selectQuery uses 'local' instead of 'remote'. Is it possible I need something else to make this work?

Mihir Bhende Over a year ago

If its different servers altogether then you need to create a table with federated engine.

Collectives™ on Stack Overflow

Two database connection in one query in Laravel

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related