mysql外部キーの操作
1936 ワード
: :alter table add constraint FK_ID foreign key( ) REFERENCES ( ); : alter table tb_active add constraint FK_ID foreign key(user_id) REFERENCES tb_user(id)
： ALTER TABLE table-name DROP FOREIGN KEY key-id; ： ALTER TABLE `tb_active` DROP FOREIGN KEY `FK_ID`
//FK_ID /* CREATE TABLE `tb_active` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `user_id_2` (`user_id`), CONSTRAINT `FK_ID` FOREIGN KEY (`user_id`) REFERENCES `tb_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 */
： ， ， REFERENCES ？ ? ， ， ，MYSQL FOREIGN KEY...REFERENCES ON DELETE ON UPDATE ， show create table locstock