/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

13 votes310 views6 answers
Current date sql
SQL
0 vote300 views1 answer
What is between operator
SQL
7 votes319 views1 answer
Alter sequence set current value oracle
SQL
1 vote310 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote542 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
4 votes311 views2 answers
Sql table
SQL
4 votes329 views3 answers
Check if two date ranges overlap sql server
SQL
-1 vote311 views1 answer
Su: Authentication failure mysql
SQL
3 votes332 views1 answer
Sql insert inserted id
SQL
1 vote363 views1 answer
Create email address from first and last name in sql
SQL