Rearrange columns in a Laravel migration file

Question

How do I re-arrange a column in a Laravel migration file for a MySQL database?

So far I have the following:

$table->date('foo')->after('bar')->change();

However, it does not seem to re-arrange the column.

Why not and how can I fix this?

Answer 1

Can't see anything in Laravel Schema API that will allow you to rearrange columns. Your best bet will be to use raw SQL statement as below.

 DB::statement("ALTER TABLE table_name MODIFY COLUMN col_name col_definition AFTER another_col");

Answer 2

Try this, hope it help you to find right solution:

public function up()
{
    DB::statement("ALTER TABLE example MODIFY COLUMN foo DATE AFTER bar");
}

public function down()
{
    DB::statement("ALTER TABLE example MODIFY COLUMN foo DATE AFTER bar"); 
}