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

0 vote165 views1 answer
Reindexing all tables sql server
SQL
0 vote130 views2 answers
Mysql update two tables at once
SQL
0 vote127 views1 answer
Multiple left join mysql
SQL
6 votes139 views2 answers
Sql display max value
SQL
0 vote142 views1 answer
How to move a column to different spot mysql
SQL
0 vote87 views1 answer
Check sql query executed wp
SQL
0 vote123 views1 answer
Mysql Error Code: 1005
SQL
7 votes140 views1 answer
Oracle reset sequence
SQL
0 vote144 views1 answer
Order child below the parent in mysqli
SQL
1 vote128 views1 answer
Update and replace mysql
SQL