CREATE MULTIPLE FK

/* RENAME FK's FOR BETTER :) */
/* Name it fk_food */

  CONSTRAINT `fk_food`
    FOREIGN KEY (`food` )
    REFERENCES `mydb`.`food` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  /* Name it fk_restaurant */
  
  CONSTRAINT `fk_restaurant`
    FOREIGN KEY (`restaurant` )
    REFERENCES `mydb`.`restaurants` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
    
    );

Similar codes

1 vote195 views1 answer
Can we drop a primary key
SQL
0 vote194 views1 answer
Mql5 list all available symbols
SQL
2 votes221 views1 answer
Sql missing records from another table
SQL
0 vote161 views1 answer
Oracle last user logon
SQL
0 vote234 views1 answer
Sql order by except one row
SQL
4 votes249 views4 answers
Mysql get date from datetime
SQL
0 vote209 views1 answer
Sql server whoami
SQL
0 vote221 views1 answer
Drop CHECK constraint sql
SQL
10 votes254 views6 answers
Mysql set root password
SQL
20 votes229 views6 answers
Mysql reset auto increment
SQL