How to copy existing table in Laravel?

laravel copy row to another table
laravel replicate
laravel clone query
where like laravel
laravel exists
laravel union
wherebetween laravel
laravel where between

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

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.

How to copy entire table in database?, #I want to know how to copy existing table through PHP script. I want to create a table for each user and copy all the contents of the existed  Further, I notice that if I pass an invalid/non-existent table name, e.g., setTable('table_does_not_exist'), the call still returns true. Any assistance in this regard would be much appreciated! Thanks in advance!

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

Copy Table Row in Laravel using Eloquent replicate – 5 Balloons, I came across a problem where in I had to make the exact copy of the Eloquent Model and save it in the database table after changing some of its  Use a specific name to avoid clashing with existing models . for Laravel 3: php artisan migrate:make add_paid_to_users for Laravel 5+: php artisan make:migration add_paid_to_users_table --table=users You then need to use the Schema::table() method (as you're accessing an existing table, not creating a new one). And you can add a column like this:

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

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

Eloquent: how to make a copy of a row, This function allows you to make a copy of a row in the fastest way possible. To start with, we are going to have a table: Schema::create('tasks'  I want to change my two table name in the Laravel, so do I have to manually change the table name or it can be possible through migration.

Database table clone, Hi, I want to do clone table from another database connection by Model. But I cannot. code is here $customer = Customer::on('mysql2')->  Create a brand new separate Laravel app/instance. Make a model for each database table (excluding relational tables). Put this app on a separate domain and link between the projects while you work on this one. Create new pages and logic only on the new app. Optionally replace the old app's pages one by one.

How best to copy a row of data from one table to another?, I have a need to copy a row of data from one database table to another. What is the best means by which to accomplish this in Laravel? The Laravel Schema facade provides database agnostic support for creating and manipulating tables across all of Laravel's supported database systems. Generating Migrations. To create a migration, use the make:migration Artisan command: php artisan make:migration create_users_table. The new migration will be placed in your database/migrations directory. Each migration file name contains a timestamp, which allows Laravel to determine the order of the migrations.

Copy production database data to staging or local database with , I recently had a need to be able to migrate and seed a staging database with Copy production database data to staging or local database with only a Laravel Seed $live_database = DB::connection('mysql');// Get table data from production 1) artisan migrate:make import_sql : in that file you import the db.sql file that you can put eg in your app/database folder., calling mysqldump from laravel. 2) artisan migrate:make structure_change : dropColumn, create tables . the classical way.

Comments
  • Post is as an answer if it works, it's not helpful for others in a comment, doesn't look clear.
  • You can except your answer :-)
  • Why should the OP "try this"? A good answer will always have an explanation of what was done and why it was done that way, not only for the OP but for future visitors to SO that may find this question and be reading your answer.