SQLSTATE [42S01]:基本表或视图已存在或基本表或视图已存在:1050表 [英] SQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Table
问题描述
这是我的迁移表
<?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->increments('id');
$table->integer('role_id')->unsigned();
$table->string('name');
$table->string('email',50)->unique();
$table->string('username');
$table->string('password');
$table->boolean('active');
$table->rememberToken();
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('users');
}
}
当我尝试迁移时会发生以下错误
when ever i try to migrate the following error occur
* [Illuminate \ Database \ QueryException]
SQLSTATE [42S01]:基本表或视图已经存在:1050表'users'alre
ady存在(SQL:创建表users
(id
int unsigned not null auto_incr
水泥主键,role_id
int unsigned不为null,name
varchar(191)不为
null,email
varchar(50)不为空,username
varchar(191)不为空,pas
sword
varchar(191)不为空,active
tinyint(1)不为空,remember_token
varchar(100)为空,created_at
时间戳为null,updated_at
时间戳为nu
ll)默认字符集utf8mb4整理utf8mb4_unicode_ci)
*[Illuminate\Database\QueryException]
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' alre
ady exists (SQL: create table users
(id
int unsigned not null auto_incr
ement primary key, role_id
int unsigned not null, name
varchar(191) not
null, email
varchar(50) not null, username
varchar(191) not null, pas
sword
varchar(191) not null, active
tinyint(1) not null, remember_token
varchar(100) null, created_at
timestamp null, updated_at
timestamp nu
ll) default character set utf8mb4 collate utf8mb4_unicode_ci)
[PDOException] SQLSTATE [42S01]:基本表或视图已存在:1050表'users'all 阿迪存在*
[PDOException] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' alre ady exists*
请告诉我该怎么办?我已经使用过migration:reset或dumpautoload或rollback没有任何反应.很多时间我都编辑或删除了这个usersfile并重新创建了它.
推荐答案
尝试这样
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateUserTable extends Migration
{
public function up()
{
Schema::dropIfExists('users');
Schema::create('users', function (Blueprint $table) {
$table->increments('id');
$table->integer('role_id')->unsigned();
$table->string('name');
$table->string('email',50)->unique();
$table->string('username');
$table->string('password');
$table->boolean('active');
$table->rememberToken();
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('users');
}
}
这篇关于SQLSTATE [42S01]:基本表或视图已存在或基本表或视图已存在:1050表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!