Originally posted @ https://codeanddeploy.com visit and download the sample code:
https://codeanddeploy.com/blog/laravel/how-to-create-table-using-laravel-8-migration-artisan-command
In this post, I will show you a guide on how to create a table using the Laravel migration artisan command. If your using Laravel it allows us to create table easily using the artisan command and help us to modify the database and stay up to date without any mess.
If you are new to Laravel and want to know how to do it for example this post is for you. Just follow the guide below on how to create a table using migrations in Laravel 8.
Step 1: Create Laravel Migration
Now let's create our first Laravel migration in this example we will create a simple products table. I assume that you already know how to run artisan command in Laravel 8.
php artisan make:migration create_products_table
After you run the above command it will generate a migration file: database/migrations/2021_11_20_022433_create_products_table.php see below-generated code:
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateProductsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('products', function (Blueprint $table) {
$table->id();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('products');
}
}
Now, let's add our basic columns for the products table. Here is the updated code:
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateProductsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('products', function (Blueprint $table) {
$table->id();
$table->string('title');
$table->string('description');
$table->decimal('price', 15, 2);
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('products');
}
}
Step 2: Run Laravel Migration
Then now let's run the command to migrate our newly created migration. Run the following command below:
php artisan migrate
After you run the above command let's check to our phpmyadmin area.
Laravel Migration Command Options
Now, let's learn basic Laravel migration command options.
Create a Migration with Table:
php artisan make:migration create_products_table --table=products
Run Specific Migration:
php artisan migrate --path=/database/migrations/2021_11_20_022433_create_products_table.php
Migration Rollback:
php artisan migrate:rollback
To know more about Laravel migrations visit here.
I hope this tutorial can help you. Kindly visit here https://codeanddeploy.com/blog/laravel/how-to-create-table-using-laravel-8-migration-artisan-command if you want to download this code.
Happy coding :)
Top comments (0)