如果要對(duì)UPDATE 和 DELETE 加上 CASCADE,可以這么寫
CREATE?TABLE?users1?(id?SMALLINT?UNSIGNED?PRIMARY?KEY?AUTO_INCREMENT,?username?VARCHAR(10)?NOT?NULL,?pid?SMALLINT?UNSIGNED,?FOREIGN?KEY?(pid)?REFERENCES?provinces?(id)?ON?DELETE?CASCADE?ON?UPDATE?CASCADE);
如果要對(duì)UPDATE 和 DELETE 加上 CASCADE,可以這么寫
CREATE?TABLE?users1?(id?SMALLINT?UNSIGNED?PRIMARY?KEY?AUTO_INCREMENT,?username?VARCHAR(10)?NOT?NULL,?pid?SMALLINT?UNSIGNED,?FOREIGN?KEY?(pid)?REFERENCES?provinces?(id)?ON?DELETE?CASCADE?ON?UPDATE?CASCADE);
2014-10-26
舉報(bào)