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 vote116 views1 answer
Postgresql contains
SQL
7 votes116 views1 answer
Alter sequence set current value oracle
SQL
25 votes125 views5 answers
Uninstall mysql ubuntu
SQL
0 vote112 views1 answer
Oracle archivelog usage
SQL
0 vote117 views1 answer
18446744073709551615 mariadb left join order by
SQL
1 vote133 views1 answer
Mysql check if string contains comma separated
SQL
0 vote94 views1 answer
Mysql regex exact match
SQL
0 vote117 views1 answer
Mysql dump everythign
SQL
0 vote107 views1 answer
Sql cross apply vs join
SQL
0 vote128 views1 answer
Postgres execute multiple sql file from command line
SQL