Make column invalid in Laravel migration

Question

I am writing a transition to create specific columns in a nullable table right now. For the down function, of course I want to make these columns not nullable . I looked at the schematic layout designer , but couldn't see a way to do this.

Any help would be appreciated.

Answer 1

Prior to Laravel 5, there was no native Laravel way to modify an existing table column using a schema builder. You will need to use raw requests.

However, with Laravel 5 you can use:

 $table->...->nullable(false)->change(); 

Answer 2

As in Laravel 5, you can undo this initially - just pass false as an argument to nullable ().

eg.

 $table -> string('foo') -> nullable(false) -> change(); 

Answer 3

the information below is for SQL
First use the code below

 UPDATE [Table] SET [Column]=0 WHERE [Column] IS NULL 

how to run this code

 ALTER TABLE [Table] MODIFY [Column] INTEGER NOT NULL