Create MySQL tables

Creating MySQL database tables from Laravel

To follow Laravel standards, We should create a table using Laravel artisan commands. It will help to other teammates automatically update database changes just with one command. To create a table use below command.

php artisan make:migration create_yourTableName_table

It will create a table and you can also check the migrate files in the below path

mylaravel\database\migrations\

Let's create sample table name called "posts"

php artisan make:migration create_posts_table

Creating "posts" Table

After run this command, Migration file will be created. you can check the migration folder

Migration file

Let's add some columns in the posts table

public function up()
    {
        Schema::create('posts', function (Blueprint $table) {
            $table->id();
            $table->string('slug');
            $table->text('body');
            $table->timestamp('publised_at')->nullable();
            $table->timestamps();
        });
    }

before running migration, Let's see the MySQL database

Before running migrate

After running migration php artisan migrate

It will add some default Laravel migrations also, now check at database

posts table created

columns are added

Suppose If I want to add another column to the "posts" table. Like 'title' column.

In this case, you can simple run the migration command

php artisan make:migration add_title_to_posts_table

Creates one more migration file

Migration file

As discussed it creates one more migration file, now we need to add our "title" column here as well as we need to write down() method for drop the changes.

Add title column