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 vote125 views1 answer
Python mysql show databases
SQL
0 vote124 views1 answer
T-sql conditional order by multiple columns
SQL
11 votes138 views5 answers
Sql server reset identity
SQL
1 vote132 views1 answer
Postgres count string length
SQL
1 vote132 views3 answers
Drop unique key constraint in sql server
SQL
0 vote124 views1 answer
Get employees if not contains in sql
SQL
0 vote138 views2 answers
Cascade syntax in sql
SQL
4 votes133 views1 answer
Group by mysql and concatenate string
SQL
0 vote119 views1 answer
See Foreign Key
SQL
8 votes135 views1 answer
Mac restore mysql database command line
SQL