/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

1 vote113 views1 answer
Type int in mysql maxlenght
SQL
7 votes111 views2 answers
Sql server drop temp table if exists
SQL
0 vote113 views1 answer
Plsql check for string in numeric
SQL
6 votes124 views4 answers
Mysql group by month
SQL
0 vote106 views1 answer
Sql server whoami
SQL
0 vote111 views1 answer
Sql query to delete row by id
SQL
0 vote141 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote117 views1 answer
Mysql add to number
SQL
7 votes114 views3 answers
Convert ansi sql
SQL
0 vote155 views1 answer
Sql query to select even numbers
SQL