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 vote270 views1 answer
Sql server system messeges
SQL
5 votes233 views3 answers
Sql server utc to local
SQL
18 votes180 views6 answers
Creating table in MySQL
SQL
2 votes201 views1 answer
Drop sequence
SQL
4 votes308 views2 answers
Sql select except null
SQL
10 votes200 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote139 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote194 views1 answer
Typical max-connect-errors mysql
SQL
0 vote184 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote186 views1 answer
Firebird where
SQL