Guest User

Untitled

a guest
May 25th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. 'mysql' => [
  2. 'driver' => 'mysql',
  3. 'host' => env('DB_HOST', '127.0.0.1'),
  4. 'port' => env('DB_PORT', '3306'),
  5. 'database' => env('DB_DATABASE', 'db1'),
  6. 'username' => env('DB_USERNAME', 'root'),
  7. 'password' => env('DB_PASSWORD', ''),
  8. ...
  9. ],
  10.  
  11. 'mysql2' => [
  12. 'driver' => 'mysql',
  13. 'host' => env('DB_HOST_2', '127.0.0.1'),
  14. 'port' => env('DB_PORT_2', '3306'),
  15. 'database' => env('DB_DATABASE_2', 'db2'),
  16. 'username' => env('DB_USERNAME_2', 'root'),
  17. 'password' => env('DB_PASSWORD_2', ''),
  18. ...
  19. ],
  20.  
  21. $user= DB::connection("mysql2")->table('User')
  22. ->join('ticket', 'User.Id', '=','ticket.user_id')
  23. ->select('User.*')
  24. ->where('ticket.id', '=', 1)
  25. ->get();
  26.  
  27. CREATE VIEW `D2`.`example` AS SELECT * FROM `D1`.`T1`;
Add Comment
Please, Sign In to add comment