hibernate CommandAcceptanceException: Error executing DDL
schema.spi.CommandAcceptanceException: Error executing DDL "alter table idm_role_users add constraint FKbbb0hf3h6de22q346hty2916d foreign key (users_id) references idm_user (id)"
某一个表中已经存在数据;此时不能拥修改表约束;
CREATE TABLE IF NOT EXISTS `student`(
`id` INT(11) AUTO_INCREMENT,
`name` VARCHAR(32),
`age` int(11),
`t_id` int(11),
PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `teacher`(
`id` INT(11) AUTO_INCREMENT,
`name` VARCHAR(32),
`age` int(11),
`t_id` int(11),
PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into teacher values(1,'zs',19,1);
-- ------------------
alter table student add constraint fff_k1 foreign key (t_id) references teacher (id);
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步