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 vote240 views1 answer
Hexadec to sql REDSHIFT
SQL
0 vote285 views1 answer
Plpgsql create function
SQL
0 vote250 views1 answer
Python connect to mysql in settings.py
SQL
6 votes276 views2 answers
Install psql mac
SQL
25 votes245 views4 answers
Sqlserver add column
SQL
0 vote228 views1 answer
Get time component of datetime sql
SQL
0 vote238 views1 answer
Rename constraint postgresql
SQL
7 votes256 views1 answer
Query postgres delete duplicates
SQL
8 votes247 views2 answers
Grant all privileges database postgres to user
SQL
-1 vote225 views1 answer
Export mysql table to file
SQL