It not work, I search so many ways, How can I change length of value in laravel 5
public function up()
{
Schema::table('articles', function (Blueprint $table) {
$table->string('name',50)->change();
});
}
Thank you all for reading!
Regarding documentation, your example should work:
Schema::table('users', function ($table) {
$table->string('name', 50)->change();
});
Just run php artisan migrate command to execute it.
At least in Laravel 5.6, if it is requiring Doctrine DBAL and you don't want to install it now for any reason, you can try this:
<?php
// ...
Schema::table('users', function ($table) {
DB::statement('ALTER TABLE users MODIFY COLUMN name VARCHAR(50)');
});
There is an outstanding (open for multiple years and still being discussed) issue related to Doctrine DBAL (discussion here: https://github.com/laravel/framework/issues/1186).
The deceptive part of this issue is that a ->change() will fail if any column is of type enum (not just the column you are changing!)
If your table has an enum column, you need to revert to using an alter statement (note you don't need to wrap it in a Table::schema:
DB::statement('ALTER TABLE users MODIFY COLUMN name VARCHAR(50)')
In case you have to change a column length which previously had a foreign key and an index, you should drop them first in a different Schema block, not in the same one as you change the length, as doing so will get you an error.
Schema::disableForeignKeyConstraints();
Schema::table('table_name', function (Blueprint $table) {
$table->dropIndex('table_column_index');
$table->dropForeign('table_column_foreign');
});
Schema::enableForeignKeyConstraints();
Schema::table('table_name', function (Blueprint $table) {
$table->string('column', 100)->change();
});
