[Solved] PHP SQL / Duplicate entries

by

[ad_1]

Create a unique index on Col A and Col B:

MySQL:

ALTER TABLE `mytable` ADD UNIQUE `unique_index`(`ColA`, `ColB`);

ANSI SQL example:

ALTER TABLE mytable ADD CONSTRAINT unique_index UNIQUE (ColA,ColB);

2

[ad_2]

solved PHP SQL / Duplicate entries