I hope someone can teach me how to create a temporary table . I'm using laravel 4.
CREATE TEMPORARY TABLE temptable ( select * from permanent);
I hope someone can teach me how to do this in Laravel way. Thanks in advance!
We can create temporary table using Laravel 4
Example:
// CREATE TEMPORARY TABLE
$productList = DB::insert( DB::raw( "CREATE TEMPORARY TABLE tempproducts
") );
// DELETE TEMPORARY TABLE
$dropTable = DB::unprepared( DB::raw( "DROP TEMPORARY TABLE tempproducts
" ) );
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community