Laravel Migration create table from existing table

Question

I am working on such application where table audit should perform to make revision of updated records. Let's say for example I have to log each field update in Users update.

I wants to create clone of existing user table by

CREATE TABLE users_audit LIKE users;

My main question is, Is there any alternative way or provision in Laravel migration to create table from existing table ?

I know we can run raw sql query in migration up/down method using \DB::raw();

But it would be helpful if any helper function available to create table from existing table like, create or table

maybe you wanna have a look at this github.com/Xethron/migrations-generator — usrNotFound
– usrNotFound, Commented Dec 8, 2017 at 5:12
yes, @usrNotFound we can use but for just one table I won't interested to add whole library — Chintan7027
– Chintan7027, Commented Dec 8, 2017 at 5:27
you can use php artisan migrate:generate table1,table2,table3,table4,table5 as many tables as you want — usrNotFound
– usrNotFound, Commented Dec 8, 2017 at 5:28

Akeel ahamed · Accepted Answer · 2018-11-12 10:35:38Z

1

Yes, you can, see the below link

Click this link

This statement is used to execute raw queries

DB::statement('CREATE TABLE tablename LIKE existingtablename');

answered Nov 12, 2018 at 10:35

Akeel ahamed

1,09713 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel Migration create table from existing table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related