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

4 votes141 views1 answer
Oracle show errors compilation
SQL
7 votes249 views2 answers
Mysql default value
SQL
16 votes148 views4 answers
Sort by sql
SQL
0 vote138 views1 answer
Sql date between one week
SQL
18 votes190 views3 answers
Get the list of all tables in sql server
SQL
3 votes186 views5 answers
Duplicate table sql
SQL
2 votes140 views3 answers
Mysql unix timestamp to date
SQL
0 vote170 views1 answer
Postgresql conectar
SQL
10 votes194 views1 answer
Oracle all_dependencies
SQL
-1 vote145 views1 answer
Mysql #1064 error
SQL