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

2 votes301 views1 answer
Date conversion in mysql column
SQL
0 vote288 views1 answer
How much table store postgres
SQL
0 vote302 views1 answer
MySQL get all previous date record
SQL
0 vote311 views1 answer
Insert overwrite table in mysql in nifi
SQL
16 votes348 views1 answer
Sqlserver add column to table
SQL
0 vote309 views1 answer
Mysql make date from 2 column
SQL
7 votes314 views1 answer
Oracle pagination query offset
SQL
17 votes303 views3 answers
Postgresql version command
SQL
2 votes279 views1 answer
Mysql add boolean column
SQL
0 vote303 views1 answer
How to add more columns to a table in mysql
SQL