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 vote258 views4 answers
Change schema in sql server
SQL
0 vote242 views1 answer
Dasebase_url-postgres for windows
SQL
2 votes280 views3 answers
How do I add a user to a postgres database? cli
SQL
15 votes259 views3 answers
Find duplicate keys in mysql
SQL
1 vote262 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote280 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
16 votes235 views3 answers
Order by sql query
SQL
1 vote267 views1 answer
Psql human readable
SQL
1 vote282 views1 answer
Psql view enum values
SQL
2 votes298 views2 answers
Python escape string for sql
SQL