Support the ongoing development of Laravel.io →
posted 11 years ago
Database

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!

Last updated 2 years ago.
0

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" ) );

Last updated 2 years ago.
0

how to create collum in created table? I am using laravel 5.1

0

Sign in to participate in this thread!

Eventy

Your banner here too?

helmikuu27 helmikuu27 Joined 31 Mar 2014

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.