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 vote56 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
5 votes129 views3 answers
Show indexes mysql
SQL
1 vote103 views2 answers
Mysql switch case
SQL
0 vote103 views1 answer
Set column in all row mysql
SQL
0 vote105 views1 answer
SQL Server modify_timestamp trigger
SQL
1 vote108 views1 answer
Oracle turn off constraint
SQL
103 votes258 views1 answer
Like sql
SQL
0 vote99 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote110 views1 answer
Alter owner in PostgreSQL
SQL
1 vote135 views1 answer
Hangfire clear all jobs
SQL