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

1 vote114 views1 answer
How to set up a trigger in sql
SQL
0 vote102 views2 answers
Search stored procedures
SQL
0 vote109 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote175 views1 answer
How to find the most occuring in SQL
SQL
9 votes103 views3 answers
Where in sql
SQL
0 vote133 views2 answers
Mysql where in maintain order group_concat
SQL
1 vote114 views1 answer
Nullif postgresql
SQL
2 votes115 views2 answers
Sqlite_busy: database is locked
SQL
4 votes123 views1 answer
T-sql get duplicate rows
SQL
1 vote124 views1 answer
Increase date by one day in sql oracle
SQL