How to add comment in Mysql column using Laravel Migrations

Question

This is what I am trying to do

if (!Schema::hasColumn('account_settings', 'minimum_onsite_length')) {
        Schema::table('account_settings', function (Blueprint $table) {
            $table->unsignedInteger('minimum_onsite_length')
                ->default(180)
                ->nullable()
                ->comment('This is comments')
            ;
        });
    }

But comments are not showing in migration is there any thing I am missing here?

I have also looked to this question but it is not working here

Possible duplicate of [How to add comment to table (not column) in Laravel 5 migration?](https://stackoverflow.com/questions/37493431/how-to-add-comment-to-table-not-column-in-laravel-5-migration) — Jigs1212, Mar 13 '18 at 12:22
Are you sure that column doesn't exist already? If it already exist then that code inside if block won't execute. — Akshay Kulkarni, Mar 13 '18 at 12:28

score 30 · Accepted Answer · edited Aug 17 '21 at 16:09

30

You can try like this,

if (!Schema::hasColumn('account_settings', 'minimum_onsite_length')) {
    Schema::table('account_settings', function (Blueprint $table) {
        $table->unsignedInteger('minimum_onsite_length')
            ->default(180)
            ->nullable()
            ->comment('This is comment');
    });
}

Ref Link here and here.

edited Aug 17 '21 at 16:09

Arda

6,756
3
47
67

answered Mar 13 '18 at 12:33

Rahul

18,271
7
41
60

3

According to official document of Laravel 5.7, comment can be added by "->comment('my comment')". https://laravel.com/docs/5.7/migrations – Kamlesh Jan 31 '19 at 18:14
1

Can confirm that, `->comment('my comment');` also works on Laravel 4.2. – Arda Mar 04 '19 at 09:06
2

I can confirm `->comment('my comment')` does work till date up to 7.x. More on official documentation https://laravel.com/docs/7.x/migrations#column-modifiers – Hashmat Jul 04 '20 at 04:03

How to add comment in Mysql column using Laravel Migrations

1 Answers1