title: SQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Table
body: <p>Here my migration table</p>
  
  <pre><code>    &lt;?php
  
  use Illuminate\Support\Facades\Schema;
  use Illuminate\Database\Schema\Blueprint;
  use Illuminate\Database\Migrations\Migration;
  
  class CreateUserTable extends Migration
  {
  
      public function up()
      {
          Schema::create('users', function (Blueprint $table) {
              $table-&gt;increments('id');
              $table-&gt;integer('role_id')-&gt;unsigned();
              $table-&gt;string('name');
              $table-&gt;string('email',50)-&gt;unique();
              $table-&gt;string('username');
              $table-&gt;string('password');
              $table-&gt;boolean('active');
              $table-&gt;rememberToken();
              $table-&gt;timestamps();
  
          });
      }
  
      public function down()
      {
          Schema::dropIfExists('users');
      }
  }
  </code></pre>
  
  <p>when ever i try to migrate the following error occur </p>
  
  <p>*[Illuminate\Database\QueryException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' alre
  ady exists (SQL: create table <code>users</code> (<code>id</code> int unsigned not null auto_incr
  ement primary key, <code>role_id</code> int unsigned not null, <code>name</code> varchar(191) not
   null, <code>email</code> varchar(50) not null, <code>username</code> varchar(191) not null, <code>pas
  sword</code> varchar(191) not null, <code>active</code> tinyint(1) not null, <code>remember_token
  </code> varchar(100) null, <code>created_at</code> timestamp null, <code>updated_at</code> timestamp nu
  ll) default character set utf8mb4 collate utf8mb4_unicode_ci)</p>
  
  <p>[PDOException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' alre
  ady exists*</p>
  
  <p><strong>please tell me what should i do ?? i have already use migrate:reset or dumpautoload or rollback nothing happen . lots of time i edit or delete this usersfile and recreated it .</strong>  </p>