/SQL/Mysql bidirectional composite primary key

Mysql bidirectional composite primary key

create trigger bi_foo before insert on foo
for each row
begin
  if exists(select 1 from foo where bar1 = NEW.bar2 and bar2 = NEW.bar1)
  then
    signal sqlstate '50000' set message_text="Oops";
  end if;
end

Source: stackoverflow.com

Mysql bidirectional composite primary key

CREATE TRIGGER uinsert BEFORE INSERT ON tbl_challenger
 FOR EACH ROW SET NEW.u0 = LEAST(NEW.host,NEW.challenger),
  NEW.u1 = GREATEST(NEW.host,NEW.challenger);
#same for update
CREATE UNIQUE INDEX uniqueness ON tbl_challenger(u0,u1);

Source: stackoverflow.com

Similar codes

0 vote318 views1 answer
Setting default value for Boolean data type in SQL
SQL
7 votes186 views6 answers
Nth highest salary in sql
SQL
1 vote197 views1 answer
Rermove categories woocommerce sql
SQL
0 vote193 views1 answer
Mysql coonect sample code
SQL
1 vote185 views1 answer
Mysql select month and year
SQL
0 vote196 views1 answer
Sum values by month mariadb
SQL
3 votes189 views1 answer
Mssql remove column
SQL
0 vote190 views1 answer
Mysql drop multiple tables at once
SQL
7 votes188 views1 answer
Minecraft forge server host
SQL
2 votes278 views1 answer
Brew start postgres manual
SQL