/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 vote363 views1 answer
Write SQL in ruby on rails
SQL
14 votes330 views3 answers
Sql trim from string
SQL
0 vote330 views1 answer
Transalations from sql to Linq count and group by
SQL
3 votes364 views3 answers
Create table in SQL Server
SQL
4 votes316 views3 answers
Mysql modify foreign key
SQL
150 votes599 views10 answers
Grepper
SQL
3 votes330 views3 answers
How to add month in update sql
SQL
5 votes314 views1 answer
Oracle find foreign key dependencies
SQL
1 vote338 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
1 vote320 views1 answer
Declare variables sql
SQL