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 vote225 views1 answer
Fetching data from mysqldb
SQL
2 votes220 views1 answer
Sqlite3 show columns name
SQL
1 vote202 views2 answers
String to date postgres
SQL
0 vote219 views4 answers
Open mysql port bitnami tomact
SQL
0 vote219 views1 answer
Mysql last friday of current month
SQL
0 vote211 views1 answer
On sql table data exists
SQL
0 vote205 views1 answer
Sql show all users
SQL
0 vote202 views1 answer
Sql convert datetime to year
SQL
3 votes209 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote215 views1 answer
Alter check command
SQL