Add updated_at column with default value same as created_at

Question

I have column 'created_at' in my table, now I want to add 'updated_at' with default value same as 'created_at'. Im using laravel migration.

        Schema::table($this->tableName(), function (Blueprint $table) {
            $table->timestamp('updated_at');
        });

write add_column_in_tableName in comand line – Abdelrahman Shahin Sep 15 '21 at 19:12 — Abdelrahman Shahin, Sep 15 '21 at 19:12
2021_05_19_123551_add_columns_to_clients.php – Abdelrahman Shahin Sep 15 '21 at 19:13 — Abdelrahman Shahin, Sep 15 '21 at 19:13

score 0 · Accepted Answer · answered Sep 15 '21 at 19:15

This would most likely be a one-off, since by default using Eloquent models, it will update both created_at and updated_at when creating a model. So after the code above, add in

DB::statement("UPDATE ".$this->tableName()." SET updated_at = created_at");

Make sure that you remove any default timestamp settings from your model, and Laravel will take it from there.

Add updated_at column with default value same as created_at

1 Answers1