Shulou(Shulou.com)06/02 Report--

How to use laravel to achieve database migration and rollback, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

When the user clicks on the member, the micro-store will get the user's information.

Next, we need to modify the table structure, which is our previous table structure, but this will not be enough for our use, because after we log in using Wechat, we can get the openid, and at this time we need to save the openid, so we need to use database migration to modify the table.

Create a migration file

Above I wrote two commands to create a migration file, and the difference between the two is whether the created file has a specified table, that is to say, the part I framed below.

When adding this migration file code, we need to know one thing, that is, after Wechat logs in, we can only get the user's openid, so the email and password in the database are null, so what we need to modify is to first add the openid field, and then modify the email,password field value to be null, the up method is to modify the database, and down is to scroll back and forth.

Let's look at the structure of the database first.

Then execute the migration file we created, and an error will be reported at this time. We did not install the library.

Install it using composer

And then in the execution, by this time, the execution has been successful.

Then let's take a look at the database structure, which has been successfully modified.

Then we can test the rollback again, because the use of rollback was not explained in the previous database migration, so just demonstrate here, using the command php artisan magrate:rollback

At this time, when we look at the table structure of the database, we will find that the table we just created and the set email and password are gone. This is a simple database rollback.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.