create table emp1 (
id int comment '编号',
name varchar(10) comment '姓名',
workno varchar(10) comment '工号',
gender char(1) comment '性别',
age tinyint unsigned comment '年龄',
idcard char(18) comment '身份证号',
workaddress varchar(50) comment '工作地址',
entrydate date comment '入职时间'
) comment '用户表';
insert into emp1 (id, name, workno, gender, age, idcard, workaddress, entrydate)
values (1,'张业','1','男',18,'12312312312323123','北京','2008-01-02'),
(2,'李晔','2','男',17,'124124124124124124','上海','2009-01-01'),
(3,'柳柳','3','女',16,'155155155155155155','北京','2007-02-03'),
(4,'王之','4','男',17,'232323232323232323','上海','2009-06-17'),
(5,'董工','5','女',15,'565656565656565656','北京','2009-08-09'),
(6,'娱乐','6','女',16,'787878787878787877','武威','2009-08-01'),
(7,'鱼鱼','7','男',14,'989889899889988989','上海','2009-08-17'),
(8,'制作','8','女',13,'343443344434343344','兰州','2009-08-18'),
(9,'达到','9','男',12,'767676767676767676','兰州','2009-08-19'),
(10,'武威','10','男',11,'891212122121212122','上海','2009-08-20'),
(11,'方法','11','女',15,'575757575775755757','山东','2009-08-21'),
(12,'丰富','12','女',17,'474747474774747474','西宁','2009-08-22'),
(13,'好好','13','男',18,'989121211221212121','宁夏','2009-08-23'),
(14,'意义','14','女',19,'321321456456787878','天水','2009-01-25'),
(15,'年年','15','女',21,'818181818181818818','姑苏','2009-01-25'),
(16,'高高','16','男',22,'991919919191919119','云梦','2009-01-24'),
(17,'巴拉','17','男',23,null,'不夜天','2009-01-26');
select id, name, workno, gender, age, idcard, workaddress, entrydate from emp1;
上面是代码,查出来的结果却足足有51行,本来应该是17行才对,但是却把原始数据显示了3遍,这是为啥呀,有大佬知道么,快哭了,从昨天查到现在网上也没有帖子说这个问题的解决方法,实在不行就只能放过了。