/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

3 votes258 views1 answer
Sql several or
SQL
1 vote288 views1 answer
Oracle datafile max size 32gb
SQL
0 vote288 views1 answer
Query string starts with vowels
SQL
57 votes471 views6 answers
Mysql alter table add column
SQL
0 vote281 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
1 vote283 views1 answer
Change old domain to new domain name wordpress
SQL
1 vote263 views2 answers
Sql groub by count
SQL
2 votes296 views2 answers
Calculate percentage in sql
SQL
0 vote300 views1 answer
Mariadb create index if not exists
SQL
3 votes274 views1 answer
Select nextval from sequence sql
SQL