欢迎各位兄弟 发布技术文章
这里的技术是共享的
I'm writing a migration to make certain columns in a table nullable right now. For the down function, I of course want to make those columns not nullable again. I looked through the schema builder docs, but couldn't see a way to do this.
Any help would be appreciated.
Prior to Laravel 5 there was no Laravel native way of altering an existing table column using the schema builder. You'd need to use raw queries for this.
However, as of Laravel 5 you can use:
$table->...->nullable(false)->change();/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('mytable', function(Blueprint $table) {
$table->string('mycolumn')->nullable()->change();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('mytable', function(Blueprint $table) {
/* By default it's NOT NULL */
$table->string('mycolumn')->nullable(false)->change(); // <--- here
});
}$table->string('colmn', 255)->nullable()->change();) but the reverse doesn't appear to work ($table->string('colmn', 255)->change();), so you still need to use raw db queries for this – Luís Cruz May 21 '15 at 13:41As of Laravel 5, it's possible to reverse this natively - simply pass false as an argument to nullable().
e.g.
$table -> string('foo') -> nullable(false) -> change();First run this:
composer require doctrine/dbal
Then create a migration that will alter the table like so:
php artisan make:migration fix_whatever_table_name_here
public function up()
{
Schema::table('table_name', function (Blueprint $table) {
$table->type('column')->nullable(false)->change();
});
}
public function down()
{
Schema::table('table_name', function ($table) {
$table->dropColumn('column');
});
}the below information is for SQL
Use the below code first
UPDATE [Table] SET [Column]=0 WHERE [Column] IS NULLthan run this code
ALTER TABLE [Table] MODIFY [Column] INTEGER NOT NULL
