Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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
    
    );
Comment

PREVIOUS NEXT
Code Example
Sql :: forenkey code alchemy sql 
Sql :: prodection ready postgres database step by step 
Sql :: NextBirthDayDate 
Sql :: price-colour 
Sql :: insert new department and employee record 
Sql :: how to put value in parameters in mysqldataadapter 
Sql :: SQL Combining Multiple Operators 
Sql :: Patch Applied to the Oracle Database 
Sql :: soql queries for not contact related account records in salesforce 
Sql :: how to import sqlite driver class in java using maven 
Sql :: 165001709 
Sql :: database create table date of birth data type 
Sql :: SQL Create Named CHECK Constraint 
Sql :: hoq to import database source 
Sql :: proc sql not in working 
Sql :: mysql desactivar trigger 
Sql :: Insert into ... values ( SELECT ... FROM ... ) 
Sql :: 2020 new year 
Sql :: how to check table in postgresql from terminal 
Sql :: composit key in sql 
Sql :: ring MySQL presents the usage of MySQL_Autocommit(), MySQL_Commit() & MySQL_RollBack() functions. 
Sql :: t-sql email validation 
Sql :: oracle connection 
Sql :: SQL Aliases with COUNT() 
Sql :: cahnge column name apex oracle 
Sql :: convert xml data to table format sql server 
Sql :: trigger vérifier stock 
Sql :: replace sqlalchemy 
Sql :: SQL Copy Table Schema Only 
Sql :: sql column as header 
ADD CONTENT
Topic
Content
Source link
Name
4+9 =