Sometimes we use or any other tool to create our tables and to modify the columns in the database but we also wanted to keep track of them to share the schema across the developers. phpMyAdmin So for this purpose, we have created a laravel package to keep the track of raw SQL migration using the package Laravel raw sql query migration You can read the documentation here https://github.com/Readerstacks/laravel_query_migration Let’s understand how it works Install the Package To install the package we can simply run the below command composer require readerstacks/querymigration Above Command will update your composer.json Add provider to config.php You need to update your application configuration in order to register the package so it can be loaded by Laravel, just update your file adding the following code at the end of your section: config/app.php 'providers' <?php

return [
    // ...
    'providers' => [
        Readerstacks\QueryMigration\QueryMigrationServiceProvider::class,
        // ...
    ],
    // ...
]; Publish config file Now publish config file so we can keep track of our raw SQL migrations php artisan vendor:publish --provider="Readerstacks\QueryMigration\QueryMigrationServiceProvider" Now create table in database for raw query using below command php artisan migrate Above Command will create a table in database named as . query_migrations Basic usage SQL Migration package Run Migrations php artisan QueryMigrate migrate Laravel Usage Add Query php artisan QueryMigrate add --run This will ask to enter the query to update the migration file and also run the query in the database If you want to update the migration and not wanted to run in-database then remove –run option as below php artisan QueryMigrate add Check pending migrations In your terminal type php artisan QueryMigrate pending Run migrations In your terminal type php artisan QueryMigrate migrate List all migrations In your terminal type php artisan QueryMigrate list list all migration list Run single migration only In your terminal type php artisan QueryMigrate migrate --uid=uid_of_migration Run single migration again In your terminal type php artisan QueryMigrate migrate --uid=uid_of_migration  --f To get the UID of migration you can open and find UID of query. config/query_migration_config.php Remove single migration only In your terminal type php artisan QueryMigrate remove --uid=uid_of_migration Remove All migration In your terminal type php artisan QueryMigrate removeAll Remove single migration only In your terminal type php artisan QueryMigrate remove --uid=uid_of_migration Check pending migration In your terminal type php artisan QueryMigrate pending Also published here.

Keep

Nominated for 2022 - HackerNoon Contributor of the Year - Laravel

Nominated for 2022 - HackerNoon Contributor of the Year - Sql

Too Long; Didn't Read

Boost your HackerNoon story @ $159.99! 🚀

How to Write Raw SQL Query Migration in Laravel

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

10 Use Cases for Using Laravel to Build Web App Development Projects

14 Reasons Why Laravel Is The Best PHP Framework!

2016 In Review: The Year of Exploits

148 Stories To Learn About Php

4 Must-Have Technical Requirements for an eCommerce Website

10 Use Cases for Using Laravel to Build Web App Development Projects

14 Reasons Why Laravel Is The Best PHP Framework!

2016 In Review: The Year of Exploits

148 Stories To Learn About Php

4 Must-Have Technical Requirements for an eCommerce Website

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps