CREATE TABLE users( id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, username VARCHAR(10) NOT NULL, pid SMALLINT UNSIGNED, FOREIGN (pid) REFERENCES provinces (id) ON DELETE CASCADE );
4 回答
举报
0/150
提交
取消
CREATE TABLE users( id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, username VARCHAR(10) NOT NULL, pid SMALLINT UNSIGNED, FOREIGN (pid) REFERENCES provinces (id) ON DELETE CASCADE );
2014-07-18
举报
