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 vote180 views1 answer
Oracle check table space
SQL
0 vote165 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote194 views1 answer
Postgres sequence name
SQL
10 votes174 views1 answer
Oracle dba_dependencies
SQL
7 votes182 views2 answers
N highest salary in sql
SQL
0 vote187 views2 answers
Collation in sql
SQL
0 vote221 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote173 views1 answer
Mysql return text after a final full stop
SQL
2 votes189 views1 answer
Guid to string sql
SQL
0 vote184 views2 answers
How to combine diff colmun value using group by postgres
SQL