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 vote299 views1 answer
Oracle exchange subpartition
SQL
0 vote289 views1 answer
How to change null display in psql
SQL
0 vote272 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote264 views1 answer
Oracle sql date summer time
SQL
2 votes270 views1 answer
Import database in mysql command line xampp
SQL
1 vote298 views1 answer
Tsql update datetime
SQL
0 vote287 views1 answer
Cast float mysql
SQL
0 vote279 views1 answer
Online sql testing tool
SQL
0 vote308 views1 answer
Mysql a from on this page has
SQL
0 vote307 views4 answers
Open mysql port bitnami tomact
SQL