Home >Backend Development >PHP Tutorial >How to rename database table in Laravel

How to rename database table in Laravel

藏色散人
藏色散人Original
2019-02-19 11:19:263553browse

During the project development process, sometimes you may encounter problems related to migration in Laravel, such as encountering an instance that requires renaming a table. So would you manually change the already created migrations to reflect the new table names, roll back all environments and migrate them again?

How to rename database table in Laravel

Here we introduce renaming in Laravel A simple method for database tables.

Suppose I create a table called "page_info" and I want to rename it to "page_details". I already have a migration for "create_page_info_table", so now I just need to create a new migration called "rename_page_info_table", here's what we're going to do.

Open the terminal and execute the following command:

php artisan migrate:make rename_page_info_table

Then in the newly created php file (usually located in /app/database/migration), modify the file as follows:

class RenamePageInfoTable extends Migration {
	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{	
		Schema::rename('page_info', 'page_details');
	}
	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::rename('page_details', 'page_info');
	}}

Like this, you have renamed the database table without having to manually go through all environments and databases to change the name of the table.

Recommended: "PHP Tutorial"http://www.php.cn/course/list/29.html

This article This is an introduction to the method of renaming database tables in php Laravel. I hope it will be helpful to friends who need it!

The above is the detailed content of How to rename database table in Laravel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn