CODEWITHSUNDEEP
phpdatabaselaravelcopy
Yuzo
Yuzo

Reputation: 113

How to copy existing table in Laravel?

I want to know how to copy existing table in Laravel? I am new to Laravel. I am trying to make an online exam application. I want to create a table for each user and copy all the contents of the exam table to this newly created table.

This is the script that I wanted to do. It works fine when not in laravel. What is the laravel way to do this?

$check = mysql_query("CREATE TABLE IF NOT EXISTS ".$testname." ( id INT, user VARCHAR(30), questn VARCHAR(30), ans VARCHAR(30))");

mysql_query ("INSERT IGNORE INTO ".$testname." SELECT * FROM test");

Upvotes: 7

Views: 13608

Answers (4)

Abdul Qadir R.
Abdul Qadir R.

Reputation: 1191

You can duplicate the table structure and data by the following

use Illuminate\Support\Facades\DB;

if (!Schema::hasTable('new_table_name')) { // make sure table does not exists already
    // creates table structure
    DB::statement('CREATE TABLE new_table_name LIKE old_table_name');
    //inserts table data
    DB::statement('INSERT new_table_name SELECT * FROM old_table_name');
    // Add addtional column if you watch
    if (!Schema::hasColumn('old_table_name', 'deleted_at')) {
        Schema::table('new_table_name ', function (Blueprint $table) {
            $table->softDeletes();
        });
    }
}

Upvotes: 1

Yuzo
Yuzo

Reputation: 113

Here is the solution (Someone helped me to solve this):

$db = DB::connection(); 

$sql = "CREATE TABLE IF NOT EXISTS ".$testname." ( id INT, user VARCHAR(30), questn VARCHAR(30), ans VARCHAR(30))"; 
$db->statement($sql); 

$sql = "INSERT IGNORE INTO ".$testname." SELECT * FROM test"; 
$db->statement($sql);

Upvotes: 2

Agu Dondo
Agu Dondo

Reputation: 13569

You can duplicate a DB table in Laravel using the DB::statement method like this:

\DB::statement('CREATE TABLE new_table LIKE old_table');
\DB::statement('INSERT new_table SELECT * FROM old_table');

This will duplicate the structure, indexes and data of old_table to new_table.

Upvotes: 17

user6681326
user6681326

Reputation: 11

$user = DB::connection('mysql')->select('select * from usersdata');

foreach ($user as $record) {
    $user = DB::connection('mysql1')->table("tablename")->insert(get_object_vars($record));

Upvotes: 1

Related Questions