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

4 votes179 views3 answers
Mysql update with join
SQL
7 votes191 views2 answers
Add column table pl sql
SQL
12 votes203 views5 answers
Sql primary key
SQL
10 votes202 views1 answer
All_dependencies
SQL
0 vote215 views1 answer
Foreign key type uniqu mysql
SQL
1 vote244 views1 answer
Mysql tables max count
SQL
0 vote190 views1 answer
Oracle character index
SQL
2 votes215 views5 answers
Tablespace ORACLE
SQL
0 vote203 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote197 views1 answer
How to locate pg_hba.conf file
SQL