/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 vote132 views2 answers
How to drop a unique constraint in sql
SQL
0 vote129 views1 answer
Sql list dates between two dates
SQL
0 vote83 views1 answer
Sqlalchemy filter relationship
SQL
0 vote128 views1 answer
Dapper run sql script with parameters
SQL
5 votes123 views1 answer
Sql check if date is between 2 dates
SQL
10 votes120 views5 answers
Mysql create user
SQL
-1 vote100 views2 answers
Sql query examples
SQL
0 vote125 views1 answer
With_for_update sqlalchemy
SQL
20 votes126 views6 answers
Change password in mysql
SQL
1 vote121 views1 answer
Oracle undo usage per session
SQL