How to migrate database in laravel (migrate)

Laravel is a free and open source PHP web application framework that adopts the Model-View-Controller (MVC) design pattern and provides many built-in features to make developing web applications easier. Among them, Laravel Migrate is a tool for database migration. It provides a simple way to manage the structure of database tables through the command line.

In actual development, we may need to modify the database structure, such as adding new tables, modifying field types, adding indexes, etc. Using Laravel Migrate can make this process easier.

So, how to use Migrate in Laravel? First, we need to create a migration file using the "php artisan make:migration" command on the command line. For example, to create a migration file named "create_users_table", you can use the following command:

php artisan make:migration create_users_table

After running this command, Laravel will create a new migration file in the "database/migrations" directory (strictly according to the time Poke sort). Open this file and we can write the operations we need to perform on the database, such as creating tables, adding fields, etc. For example, in the "create_users_table" migration file, we can use the following code to create a table named "users":

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('email')->unique();
            $table->timestamp('email_verified_at')->nullable();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('users');
    }
}

In the above code, we first introduced the two classes Schema and Blueprint to make it easier to Conveniently write database table structures. Then, in the up() method, we use the Schema::create() method to create a table named "users", which contains five fields: id, name, email, email_verified_at, password, as well as created_at, updated_at Two timestamp fields. Finally, in the down() method, we define how to bring down the table.

After completing the code writing, we can use the "php artisan migrate" command in the command line to perform the migration. This command will look for unexecuted migrations, execute the up() method in the database, and update the table structure. If you need to undo the migration, you can use the "php artisan migrate:rollback" command.

In addition to basic operations such as creating tables and modifying fields, Laravel Migrate also supports many other advanced operations, such as adding indexes, creating foreign keys, etc. In actual use, we can refer to Laravel official documentation to learn more about these operations and modify them as needed.

In short, Laravel Migrate is a very important tool in the Laravel framework, which allows us to manage the database structure more conveniently. When developing web applications, we should make reasonable use of Migrate and combine it with various Laravel built-in functions to improve development efficiency.

The above is the detailed content of How to migrate database in laravel (migrate). For more information, please follow other related articles on the PHP Chinese website!