php - SQLSTATE [42000]：语法错误或访问冲突：1067 'fechaNacimiento' 的默认值无效 - laravel

Question

我在执行迁移时出错

迁移：

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class MakeSomeColumnsNullableToPacientesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('pacientes', function (Blueprint $table) {
            $table->integer('obra_social_id')->unsigned()->nullable()->change();
            $table->integer('plan_id')->unsigned()->nullable()->change();

            $table->integer('pais_id')->unsigned()->nullable()->change();
            $table->integer('provincia_id')->unsigned()->nullable()->change();
            $table->integer('localidad_id')->unsigned()->nullable()->change();

            $table->date('fechaNacimiento')->nullable()->change();
            $table->string('telefono', 25)->nullable()->change();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('pacientes', function (Blueprint $table) {
            $table->integer('obra_social_id')->unsigned()->change();
            $table->integer('plan_id')->unsigned()->change();
        });
    }
}

请帮助 ，由于这个错误，它不允许我很好地执行迁移

fechaNacimiento ==出生日期

表格原件：$table->date('fechaNacimiento');

标签： phpmysqllaravel

Answer 1

尝试为您的列设置默认值：

$table->date('fechaNacimiento')->nullable()->default(NULL)->change();

或者：

 $table->date('fechaNacimiento')->nullable()->default('DEFAULT')->change();