Difference between revisions of "Mysql setting constraints"

  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,
 
 
CREATE TABLE notes
(
hostname VARCHAR(30),
notes VARCHAR(100),
CONSTRAINT myconst_1
FOREIGN KEY hostname
REFERENCES sslhosts (hostname)
ON DELETE CASCADE ON UPDATE CASCADE
);