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

37 votes141 views3 answers
Duplicate records in sql
SQL
10 votes136 views4 answers
Drop primary key
SQL
6 votes137 views2 answers
Mysqldump password in file
SQL
0 vote158 views3 answers
Join
SQL
9 votes135 views4 answers
Mysql show table fields
SQL
1 vote130 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote160 views2 answers
Insert data mysql with cmd
SQL
2 votes129 views1 answer
Oracle cpu per session
SQL
0 vote126 views1 answer
Dump multiple tables mysql
SQL
0 vote142 views2 answers
Identity column in sql server
SQL