I having error migrating my second table in laravel

Question

I am having a problem while running php artisan migrate on my second table after running my first users table in laravel. When I run the second table migration, I get this error:

[PDOException] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists

For those who end up being here because of the "migrations" table is not created automatically, this [link](https://stackoverflow.com/a/60095493/10539212) might help. — Phantom1412, Feb 06 '20 at 13:01

score 0 · Answer 1 · answered Aug 12 '17 at 15:47

If you are starting off using Laravel Spark or you have used an authentication layer, then the "users" table will give you that error because it already exists. Look through your migrations and you should find a table named as such.

The other possibility is that you have not set up your environment variables correctly and you are using the same database as another project. If that previous project has a "users" table, then this error will also be shown.

score 0 · Answer 2 · answered Aug 12 '17 at 15:51

Run this php artisan migrate:reset.

Next time when you want to add another table,you need to check first whether the table already exists or not. You can do this by using

if(!Schema::hasTable('users')){
    // Write your schema create code here
}

Save the file and than run php artisan migrate command.

score 0 · Accepted Answer · answered Aug 12 '17 at 15:55

0

php artisan migrate run all the migrations inside database/migrations folder. So, first you migrated the users table and then you created a new second table migration and ran this command so laravel tried to migrate the users migration again which already exists inside your database and this error is being thrown.

You need to run:

php artisan migrate:refresh

It'll will roll back all of your migrations and then execute the migrate command.

answered Aug 12 '17 at 15:55

Zayn Ali

4,765
1
30
40

Thanks for your reply, but it still not working for me, even when i run the – Famous Ighodaro Aug 12 '17 at 16:02
Please delete your `users` table from your database manually and try this again. – Zayn Ali Aug 12 '17 at 16:02
it is working now after deleting the users table but in this case, i need the user table also in my practice project. @zayn Ali – Famous Ighodaro Aug 12 '17 at 16:28
@FamousIghodaro Yes because laravel also creates a `migrations` table inside the database to keep track of all. – Zayn Ali Aug 12 '17 at 16:37

score 0 · Answer 4 · answered Sep 15 '17 at 13:32

I have solved this Problem

Laravel 5.5 Error Base table or view already exists: 1050 Table 'users' already exists

by Changing My create_users_table.php

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::dropIfExists('users');
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('email')->unique();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('users');
    }
}

I having error migrating my second table in laravel

4 Answers4