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

2 votes142 views1 answer
Mysql query unique column
SQL
0 vote138 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
1 vote146 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
2 votes189 views1 answer
Datefromparts mssql
SQL
31 votes202 views4 answers
Mysql grant execute
SQL
0 vote168 views1 answer
Sql count total by foreign key
SQL
0 vote141 views1 answer
Formatting code with SQL Developer
SQL
-1 vote151 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
2 votes151 views2 answers
Sql percentage
SQL
1 vote146 views1 answer
Mysql text to decimal
SQL