Add more column in existing table but it doesn't

Question

$ php artisan migrate

In Connection.php line 647:

  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, `name` varchar(191) not null, `email` varchar(191) not n
  ull, `password` varchar(191) not null, `remember_token` varchar(100) null,
  `created_at` timestamp null, `updated_at` timestamp null) default character
   set utf8mb4 collate utf8mb4_unicode_ci)


In Connection.php line 449:

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

I am trying to add more column into users table but I can't. In terminal I write command php artisan migrate but Base table or view already exists: 1050 Table 'users' already exists. What can I do now?

do not use `Schema::create` use `Schema::table` to add more columns — Sakezzz, May 20 '18 at 08:31

score 0 · Answer 1 · answered May 20 '18 at 08:38

0

Use PHP artisan migrate:refresh it will remove all table and create again all or use Schema::table to add more columns

answered May 20 '18 at 08:38

Nishit Manjarawala

451
4
20

I also try it but SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists. – sam sam May 20 '18 at 11:53
go to database and delete all table manually – Nishit Manjarawala May 21 '18 at 04:42
Thanks. It's working. – sam sam May 21 '18 at 11:09
then up vote please – Nishit Manjarawala May 22 '18 at 04:38

score 0 · Answer 2 · answered May 20 '18 at 08:40

0

You need to reference the table instead of calling the create method

Schema::table('users', function (Blueprint $table) {
    $table->string('email');
});

see Laravel Documentation

answered May 20 '18 at 08:40

Ben V.

211
1
3

Add more column in existing table but it doesn't

2 Answers2