Difference between revisions of "Mysql setting constraints"

From MyWiki
Jump to: navigation, search
(Created page with "<source lang="sql"> CONSTRAINT education_ibfk_1 FOREIGN KEY (profile_id) REFERENCES Profile (profile_id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT educat...")
 
Line 9: Line 9:
 
     ON DELETE CASCADE ON UPDATE CASCADE,
 
     ON DELETE CASCADE ON UPDATE CASCADE,
 
</source>
 
</source>
 +
http://www.mysqltutorial.org/mysql-primary-key/<br>

Revision as of 12:01, 22 January 2019

  CONSTRAINT education_ibfk_1
    FOREIGN KEY (profile_id)
    REFERENCES Profile (profile_id)
    ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT education_ibfk_2
    FOREIGN KEY (institution_id)
    REFERENCES Institution (institution_id)
    ON DELETE CASCADE ON UPDATE CASCADE,

http://www.mysqltutorial.org/mysql-primary-key/