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

0 vote322 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote308 views1 answer
Delete insert record in sql server
SQL
0 vote378 views1 answer
Mysql, how to query the table comments?
SQL
0 vote328 views1 answer
Java check if something is in mysql table
SQL
0 vote340 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote313 views1 answer
What is between operator
SQL
8 votes304 views2 answers
Phpmyadmin password
SQL
0 vote335 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote327 views1 answer
Limiting query result using where in sql
SQL
1 vote319 views1 answer
How much every mysql database record takes from diskspace
SQL