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

33 votes366 views6 answers
Sql delete
SQL
5 votes298 views1 answer
Oracle columns in all_tables
SQL
0 vote344 views1 answer
Sparql list all graphs
SQL
1 vote281 views1 answer
Find logged in users mysql
SQL
0 vote336 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote306 views1 answer
Install mysql for fedora 34
SQL
37 votes300 views3 answers
Postgresql insert column
SQL
9 votes301 views6 answers
Sql add column with default value
SQL
0 vote284 views1 answer
How many columns can be used for creating index?
SQL
2 votes288 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL