title: How come I can't migrate in laravel
body: <p>Migration files in laravel is used to create the tables in the database, right? But when ever I try to migrate it gives me this error:</p>
  
  <blockquote>
    <p>C:\xampp\htdocs\app>php artisan migrate</p>
    
    <p>[Illuminate\Database\QueryException]
      SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (SQL: create table <code>users</code> (<code>
      id</code> int unsigned not null auto_increment primary key, <code>name</code> varchar(255) not null, <code>email</code> varchar(255) not null,
      <code>password</code> varchar(255) not null, <code>remember_token</code> varchar(100) null, <code>created_at</code> timestamp null, <code>updated_at</code> tim
      estamp null) default character set utf8mb4 collate utf8mb4_unicode_ci)</p>
    
    <p>[PDOException]
      SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists</p>
  </blockquote>
  
  <hr>
  
  <p>and I created a new migration file and it's called test. I know users already exist but I want create the new table I created which is called test. </p>
  
  <p>here is the migration file i am going to use to create my table but wont create:</p>
  
  <pre><code>    &lt;?php
  
  use Illuminate\Support\Facades\Schema;
  use Illuminate\Database\Schema\Blueprint;
  use Illuminate\Database\Migrations\Migration;
  
  class CreateTestsTable extends Migration
  {
      /**
       * Run the migrations.
       *
       * @return void
       */
      public function up()
      {
          Schema::create('tests', function (Blueprint $table) {
              $table-&gt;increments('id');
              $table-&gt;timestamps();
          });
      }
  
      /**
       * Reverse the migrations.
       *
       * @return void
       */
      public function down()
      {
          Schema::dropIfExists('tests');
      }
  }
  </code></pre>
  
  <p>here is the users migration file that tells me it exist:</p>
  
  <pre><code>&lt;?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::create('users', function (Blueprint $table) {
              $table-&gt;increments('id');
              $table-&gt;string('name');
              $table-&gt;string('email')-&gt;unique();
              $table-&gt;string('password');
              $table-&gt;rememberToken();
              $table-&gt;timestamps();
          });
      }
  
      /**
       * Reverse the migrations.
       *
       * @return void
       */
      public function down()
      {
          Schema::dropIfExists('users');
      }
  }
  </code></pre>
  
  <p>here is the password migration file:</p>
  
  <pre><code>&lt;?php
  
  use Illuminate\Support\Facades\Schema;
  use Illuminate\Database\Schema\Blueprint;
  use Illuminate\Database\Migrations\Migration;
  
  class CreatePasswordResetsTable extends Migration
  {
      /**
       * Run the migrations.
       *
       * @return void
       */
      public function up()
      {
          Schema::create('password_resets', function (Blueprint $table) {
              $table-&gt;string('email')-&gt;index();
              $table-&gt;string('token');
              $table-&gt;timestamp('created_at')-&gt;nullable();
          });
      }
  
      /**
       * Reverse the migrations.
       *
       * @return void
       */
      public function down()
      {
          Schema::dropIfExists('password_resets');
      }
  }
  </code></pre>
  
  <p>here is the dummies migration file i have that i didn't talk about because i thought it is not the problem: </p>
  
  <pre><code>&lt;?php
  
  use Illuminate\Support\Facades\Schema;
  use Illuminate\Database\Schema\Blueprint;
  use Illuminate\Database\Migrations\Migration;
  
  class CreateDummiesTable extends Migration
  {
      /**
       * Run the migrations.
       *
       * @return void
       */
      public function up()
      {
          Schema::create('dummies', function (Blueprint $table) {
              $table-&gt;increments('id');
              $table-&gt;string('name');
              $table-&gt;text('body');
              $table-&gt;timestamp('date'); //if you dont put name for the timestamp it will create: create_at and update_at fields.
          });
      }
  
      /**
       * Reverse the migrations.
       *
       * @return void
       */
      public function down()
      {
          Schema::dropIfExists('dummies');
      }
  }
  </code></pre>
  
  <p>and sorry for keeping you guys waiting it took me long to find the edit button and fix the spacing of my code. It is my first time using stack over flow.</p>