急急急,有大佬知道datagrip为什么总是显示重复数据吗?

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遍,这是为啥呀,有大佬知道么,快哭了,从昨天查到现在网上也没有帖子说这个问题的解决方法,实在不行就只能放过了。

评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值