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

5 votes373 views3 answers
Db begintransaction laravel
SQL
1 vote345 views1 answer
Get table which have specific columns in mysql
SQL
11 votes353 views5 answers
How to install sqlite3 python
SQL
1 vote343 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
1 vote369 views1 answer
Spark sql concatenate string and int
SQL
0 vote397 views1 answer
Sql server query all database objects
SQL
0 vote389 views1 answer
Trigger vérifier stock
SQL
0 vote292 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
2 votes390 views3 answers
Mysql pass command from command line
SQL
0 vote373 views1 answer
Oracle table privileges
SQL