Difference between revisions of "Mysql setting constraints"
From MyWiki
(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...") |
|||
| (10 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 | ||
| + | |||
| + | |||
| + | |||
| + | 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; | ||
| + | |||
</source> | </source> | ||
| + | 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;
