How to add column to existing table in laravel?

Question

I'm new to laravel framework. For making a blog URL's to SEO friendly, I need to add an extra column to the existing blog tables for the laravel website. Can we directly add a column to a table directly in the database or not? Can we add a column without commands or migrations? Would you please suggest an easy method to add the column?

you can use migration as shown in this answer, or add it directly using the dbms. may we know what dbms you are using? — Bagus Tesa
– Bagus Tesa, Commented Oct 25, 2019 at 7:04
if you are using raw mysql without laravel migrations, you can use ALTER TABLE query, something like ALTER TABLE ADD COLUMN "my-new-column" varchar(MAX) or something... — Bagus Tesa
– Bagus Tesa, Commented Oct 25, 2019 at 7:51
Best solution is to use a framework the way they intent you to use it. I would strongly suggest using laravel's migrations. — killstreet
– killstreet, Commented Oct 25, 2019 at 12:40

mitesh · Accepted Answer · 2019-10-25 11:45:17Z

3

Add migration

php artisan make:migration add_fieldname_to_tablename

Code methods migration

public function up()
{
        Schema::table('tablename', function (Blueprint $table) {
            $table->datatype('column_name')->nullable();
        });
}    

public function down()
{
        Schema::table('tablename', function (Blueprint $table) {
            $table->dropColumn('column_name');
        });
}

Run migration

php artisan migrate

edited Oct 25, 2019 at 11:45

mitesh

1431 silver badge9 bronze badges

answered Oct 25, 2019 at 8:53

Nick

5462 silver badges8 bronze badges

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

Comments

Shakir Baba · Accepted Answer · 2019-10-25 07:52:43Z

1

Better is to add at migration level but if you want to directly add at DB level that is also an option. But update migration as well so that it will have all the columns.

answered Oct 25, 2019 at 7:52

Shakir Baba

3632 gold badges5 silver badges17 bronze badges

1 Comment

mitesh Over a year ago

but the best practice is to create migration file for add or create or update column in database in laravel

Collectives™ on Stack Overflow

How to add column to existing table in laravel?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related