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

8 votes202 views3 answers
Find table for column name in sql
SQL
0 vote191 views1 answer
Compare subqueries oracle
SQL
34 votes187 views5 answers
Oracle alter table add column
SQL
11 votes187 views5 answers
Sql server reset identity
SQL
0 vote159 views1 answer
IIF
SQL
5 votes190 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
1 vote167 views1 answer
Drop function
SQL
6 votes186 views2 answers
Mysql 1 day ago
SQL
0 vote170 views1 answer
Lost connection to mysql
SQL
0 vote176 views1 answer
What is between keyword used for
SQL