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 vote356 views1 answer
Show table status command in mysql
SQL
3 votes336 views2 answers
Oracle sql drop sequence
SQL
0 vote350 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote374 views1 answer
Update sql sintax
SQL
0 vote403 views1 answer
Oracle winter time change
SQL
1 vote392 views1 answer
Sqlalchemy on delete set null
SQL
2 votes355 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote367 views1 answer
Add column to table with default value plsql
SQL
0 vote374 views1 answer
Sql last time database was accessed
SQL
0 vote348 views1 answer
Update if else mysql
SQL