Difference between revisions of "Mysql setting constraints"
From MyWiki
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | https://www.percona.com/blog/2017/04/06/dealing-mysql-error-code-1215-cannot-add-foreign-key-constraint<br> | ||
| + | |||
<source lang="sql"> | <source lang="sql"> | ||
CONSTRAINT education_ibfk_1 | CONSTRAINT education_ibfk_1 | ||
| Line 8: | Line 10: | ||
REFERENCES Institution (institution_id) | REFERENCES Institution (institution_id) | ||
ON DELETE CASCADE ON UPDATE CASCADE, | ON DELETE CASCADE ON UPDATE CASCADE, | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | CREATE TABLE sslhosts ( | ||
| + | hostname varchar(30) NOT NULL, | ||
| + | port int(11) DEFAULT 443, | ||
| + | PRIMARY KEY (hostname) | ||
| + | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | ||
| + | |||
| Line 18: | Line 30: | ||
REFERENCES sslhosts (hostname) | REFERENCES sslhosts (hostname) | ||
ON DELETE CASCADE ON UPDATE CASCADE | ON DELETE CASCADE ON UPDATE CASCADE | ||
| − | ); | + | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
</source> | </source> | ||
http://www.mysqltutorial.org/mysql-primary-key/<br> | http://www.mysqltutorial.org/mysql-primary-key/<br> | ||
Latest revision as of 17:04, 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, CREATE TABLE sslhosts ( hostname VARCHAR(30) NOT NULL, port INT(11) DEFAULT 443, PRIMARY KEY (hostname) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 CREATE TABLE notes ( hostname VARCHAR(30), notes VARCHAR(100), CONSTRAINT myconst_1 FOREIGN KEY (hostname) REFERENCES sslhosts (hostname) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
