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

1 vote172 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote209 views1 answer
Postgresql conectar
SQL
1 vote171 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote179 views1 answer
Drop all procedures sql server
SQL
0 vote195 views1 answer
Plpgsql if statement
SQL
0 vote180 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote177 views1 answer
Connect by query in oracle
SQL
1 vote167 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
0 vote206 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
3 votes194 views2 answers
Sql not contains
SQL