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 vote319 views1 answer
Oracle exchange partition
SQL
6 votes337 views2 answers
What is non relational database
SQL
2 votes340 views1 answer
Mysql application.properties spring boot
SQL
0 vote328 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote315 views1 answer
Oracle synonym procedure dblink
SQL
0 vote301 views1 answer
Dump only schema
SQL
0 vote328 views4 answers
Mysql desactivar trigger
SQL
0 vote353 views1 answer
Mysql faster delete
SQL
1 vote330 views1 answer
Sql not equal multiple columns
SQL
2 votes373 views1 answer
Mysql select true or false
SQL