/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 vote171 views1 answer
Db format in quotation
SQL
7 votes168 views1 answer
Oracle pagination query offset
SQL
2 votes181 views1 answer
Guid to string sql
SQL
0 vote152 views2 answers
Postgresql create role
SQL
0 vote178 views1 answer
Mysql return column names when table is empty
SQL
3 votes180 views1 answer
Oracle apex message quit website
SQL
11 votes172 views1 answer
Sql insert multiple rows from select
SQL
32 votes178 views6 answers
How to change column name in sql
SQL
0 vote209 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote198 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL