Laravel combination unique values of three or two

Question

I want to input rows where combination of customername, pan, mobile columns must be unique so i used

$table->unique('customername', 'pan', 'mobile');

Now whether all three value's combination will be unique or either two of three will be unique?

What I want is combination of all three must be unique.

I got this error while trying above

"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'newCust' for key 'pan' (SQL: insert into `customers` (`customername`, `pan`, `customertype`, `email`, `mobile`, `offadd`, `now`, `referer_id`, `updated_at`, `created_at`) values (newCust, 1234, sasdfsdf, sdfsdf@sfdlfsdf.com, 4567, adsfasdf, sdfsdf, 2, 2014-11-23 09:47:43, 2014-11-23 09:47:43))"

complete schema

        $table->increments('id');
        $table->string('customername');
        $table->string('pan');
        $table->string('customertype');
        $table->string('email');
        $table->string('mobile');
        $table->unique('customername', 'pan', 'mobile');
        $table->text('offadd');
        $table->text('comadd');
        $table->string('website');
        $table->string('now');
        $table->string('companyname');
        $table->date('dob');
        $table->integer('referer_id');
        $table->string('status');
        $table->timestamps();

score 2 · Accepted Answer · edited May 23 '17 at 11:50

2

According to this answer you may try:

$table->unique(array('customername', 'pan', 'mobile'));

edited May 23 '17 at 11:50

Community

1
1

answered Nov 23 '14 at 09:57

Fabian Kleiser

2,988
3
27
44

1

And do this in separate `Schema::table` – baldrs Nov 23 '14 at 10:00
i leftout the array keyword i think. – Dev Abel Nov 23 '14 at 10:02
@baldrs, no, you don't need to do this in a seperate `Schema::table`. – Marwelln Nov 23 '14 at 10:31
@Marwelln I ran in a lots of errors from MySQL side when I did, so I always add indexes alongside of foreign keys now, and it works like a charm – baldrs Nov 23 '14 at 11:15

Laravel combination unique values of three or two

1 Answers1