爱码士很优秀

转载于：地址 1、建表 DROP TABLE IF EXISTS dept_tbl; CREATE TABLE dept_tbl ( rcrd_id INT UNSIGNED PRIMARY KEY auto_increment COMMENT '记录编号', dept_id INT UNSIGNED NOT NULL COMMENT '部门编号' ) ENGINE = INNODB DEFAULT charset = utf8 COMMENT '部门表'; DROP TABLE IF EXIST

参考这个博客 https://blog.youkuaiyun.com/PacosonSWJTU/article/details/84167069?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522164618994416780255273950%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=1646189944167802552