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

42 votes215 views6 answers
Sql query duplicate rows
SQL
8 votes150 views1 answer
Script to add datafile to tablespace
SQL
0 vote163 views1 answer
Mysql backup query
SQL
3 votes145 views3 answers
Update join
SQL
0 vote144 views1 answer
Supprimer les valeur d'une table mysql
SQL
1 vote146 views1 answer
Multiple count in sql
SQL
0 vote156 views1 answer
Mysqli last row
SQL
4 votes138 views2 answers
How to delete row in sql
SQL
0 vote138 views1 answer
Access refused mysql xampp server
SQL
0 vote144 views1 answer
How many rows affected in sqllite
SQL