SSM_HRMS icon indicating copy to clipboard operation
SSM_HRMS copied to clipboard

老哥,你dept表没有自增id,搞到增加部门后id全为0,删除异常

Open drinkcola opened this issue 5 years ago • 0 comments

DROP TABLE IF EXISTS tbl_dept; CREATE TABLE tbl_dept( dept_id int(11) NOT NULL DEFAULT 0,(!!!!!!!!少了个auto_increment!!!!!) dept_name VARCHAR(255) NOT NULL DEFAULT '', dept_leader VARCHAR(255) NOT NULL DEFAULT ''

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

drinkcola avatar Dec 20 '19 02:12 drinkcola