Laravel migration may look like one complicated subject but worry not; this guide will help you understand it from the basics.<\/p>\n
Laravel Migration is a process that enables you to build a table in a database without generally writing or modifying the SQL queries. It allows you to roll back changes, make incremental changes or sync the database structure simultaneously when multiple teams work on the same application. <\/p>\n
To simple understand, it is a quick method to create, destroy or bootstrap any application database. There originates no need to run a SQL query or log into the database console.<\/p>\n
While working as a team, if one needs to execute some alteration in the table, pursuing the traditional method can be hectic.<\/p>\n
While working traditionally, SQL query needs to be passed to the team member who will have the responsibility to import the file. In a situation, if they forget to do so, the application won\u2019t work accurately.<\/p>\n
To cater to such more problems, Laravel Migrations came as a saviour. It helps you get rid of any team collaboration issues in concern with databases.<\/p>\n
By utilizing the Laravel migrations, you can add new columns, delete records, and more without deleting records in your database. Rest assured of the already existing migrations, as Laravel will only do migrations that are newly added based on your request. You do not have to worry about previous migrations because Laravel has a track on the migrations already executed in the database.<\/p>\n
Let\u2019s understand it with a simple task. We will perform a database migration where we will create a table to save the application links.<\/p>\n
To do so, we will be utilizing the artisan tool that is available in artisan by default.<\/p>\n
Step 1:<\/b> We will start with the Application\u2019s root directory. Make sure that your Docker composes development environment should be up and running.<\/p>\n
Step 2:<\/b> Next, to set up the links table, you need to create a database migration.<\/p>\n
To create the same, run the make:migration Artisan command, which will bootstrap a new class in the database\/migrations folder on your Laravel application. A default boilerplate code will be present in the class by default.<\/p>\n
php artisan make:migration create_flights_table<\/p>\n
Remember: <\/b><\/p>\n
Don\u2019t forget to use the docker-compose exec app. It is used to run the command where PHP is installed on the app service container.<\/p>\n
The migration that is generated is based on the current date and time.<\/p>\n
Even the name provided make:migration command will be an argument.<\/p>\n
Step 3:<\/b> utilizing the editor of choice, open the generated migration class.<\/p>\n
Further, to include the table columns in order to store the table data, you need to update the up method.<\/p>\n
Step 4:<\/b> The next step includes the replacement of the current data. To do the same, the following codes needed to be worked on. Three new fields in the table will be added.<\/p>\n Step 5<\/b>: Save the migration file after all these entries.<\/p>\n Step 6<\/b>: Next step includes running the migration file.<\/p>\n Use the code, \u201cdocker-compose exec app PHP artisan migrate.\u201d<\/p>\n You can also get a glance at the other migrations that were executed in the same table in the database\/migrations in the app\u2019s root folder.<\/p>\n It is the most basic procedure on how you can create a table using migrations. Hope you will be able to do a much better job with this step-by-step guide.<\/p>\n Furthermore, to help you learn more about the Laravel migration, we have listed some Laravel commands that will prove to be extremely useful to you.<\/p>\n migrate:fresh<\/b> migrate:install<\/b> migrate:refresh<\/b> migrate:reset<\/b> migrate:rollback<\/b> migrate:status<\/b> Get started!<\/b> So, there stands no reason why you should not be using laravel. Be confident as you take the help of this step-by-step guide and start your laravel migration journey today!<\/p>\n We provide all-in-one Laravel Development services<\/a> starting from Website, Web Application, Web Services, Backend, RESTful API, ERP (Enterprise Resource Planning), CRM (Customer Relationship Management), SaaS (Software as a Service) and Cloud-based software based on your business needs. Skynet Technologies has expertise in developing feature-rich, robust, and customized Laravel website and web application based on your business requirements. We offer full suite of Laravel Maintenance Services<\/a> starting from website content updates, website speed optimization, SSL installation, Source Code Audit, Security Patches Updates, Bug Fixing and Troubleshooting, Broken Link Resolution, Third Party Integration, Migration or Version Upgrades.<\/p>\n","protected":false},"excerpt":{"rendered":" Laravel migration may look like one complicated subject but worry not; this guide will help you understand it from the basics. What is Laravel Migration? Laravel Migration is a process that enables you to build a table in a database without generally writing or modifying the SQL queries. It allows you to roll back changes, […]<\/p>\n","protected":false},"author":1,"featured_media":3094,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[154],"tags":[2373,2374,115,1222,2371,2376,2372,2375,1680,2363,155,156,185,1679],"yoast_head":"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\n\t\n\t\n\t\n\n
<AMP-analytics type = \u201cgoogleanalytics\u201d id = \u201canalytics1\u201d>\r\n <?php\r\n\r\nuse Illuminate\\Database\\Migrations\\Migration;\r\nuse Illuminate\\Database\\Schema\\Blueprint;\r\nuse Illuminate\\Support\\Facades\\Schema;\r\n\r\nclass CreateFlightsTable extends Migration\r\n{\r\n \/**\r\n * Run the migrations.\r\n *\r\n * @return void\r\n *\/\r\n public function up()\r\n {\r\n Schema::create('flights', function (Blueprint $table) {\r\n $table->id();\r\n $table->string('name');\r\n $table->string('airline');\r\n $table->timestamps();\r\n });\r\n }\r\n\r\n \/**\r\n * Reverse the migrations.\r\n *\r\n * @return void\r\n *\/\r\n public function down()\r\n {\r\n Schema::drop('flights');\r\n }\r\n}\r\n\r\n<\/pre>\n\n
\nUsing this command, one can drop all the tables from the database and re-run all the migrations.<\/br>
\nSyntax used: php artisan migrate:fresh<\/li>\n
\nUsing this command, a migration table can be created in a database.<\/br>
\nSyntax used: php artisan migrate:install<\/p>\n<\/li>\n
\nUsing this command, all the migrations can be rolled back, and migrations can be re-run.
\nIn simple words, the database can be re-created entirely.<\/br>
\nSyntax used: php artisan migrate:refresh<\/p>\n<\/li>\n
\nIt solely drops all the tables that you have created in a database,<\/br>
\nSyntax used: php artisan migrate:reset<\/p>\n<\/li>\n
\nThis laravel command is used to drop the last database migration.<\/br>
\nSyntax used: php artisan migrate: rollback<\/p>\n<\/li>\n
\nThis command helps you check the migration status.<\/br>
\nSyntax used: php artisan migrate: status<\/p>\n<\/li>\n<\/ul>\n
\nLaravel will ease the burden off your shoulders with its great framework. You can bid goodbye to an array of mundane tasks and can take advantage of several other features using laravel that will get your work done within seconds.<\/p>\n