登陆mysql:
找到%xampp%\mysql\bin 目录,
在此处打开命令窗口,用root用户登陆mysql
用户表建表sql:
CREATE TABLE tm_users (
id int...部门表同理。...部门表建表sql:
CREATE TABLE tm_dept (
id int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
deptid varchar(11...INTO tm_users VALUES ('14', 'zhangsan', '123', '张三', '2018-04-17 13:48:31', '2018-04-17 13:48:31', '0'...INSERT INTO tm_users VALUES ('15', 'lisi', '123', '李四', '2018-04-17 13:48:52', '2018-04-17 13:48:52', '0'