MySQL查询数据库数据显示不完整
这数据对不上应该是一个id对应一条数据
我又简写了一条sql
查出了是37条没错啊!
奇了个怪了!!!
例如 12-17
我把数据一条一条复制出来进行检查
320452,320588,320589,320591,320592,320594,320595,320597,320598,320463,
320462,320461,320460,320459,320458,320457,320456,320455,320454,320453,
320487,320486,320485,320484,320483,320482,320481,320480,320479,320478,
320477,320476,320499,320586,320603,320604,320475
dataIds 里面是37条数据,对应的filepath里面也应该是37条路径数据
但是
/yzx/20220909/762-4-bf262ce1-92ba-422a-8330-c557058a2ad8.jpg,
/yzx/20220909/762-3-a109555f-c462-42aa-ae99-1ed30330e3f1.jpg,
/yzx/20220909/762-3-c85bf4d8-3611-4048-b4ac-1817b864e195.jpg,
/yzx/20220909/762-5-4222d590-1f2d-465c-8bfb-70ddc3bdd746.jpg,
/yzx/20220909/762-4-d628cce1-10a1-410c-a82e-d99c6d75383d.jpg,
/yzx/20220909/762-3-3b9b4b0b-f9f3-46c2-8185-ca42e20e8539.jpg,
/yzx/20220909/762-5-8467d726-a01f-4599-a4cb-17f693dc166f.jpg,
/yzx/20220909/762-5-c346cedc-b986-4fff-9407-51e646ffe199.jpg,
/yzx/20220909/762-4-fa058dab-cba4-48fe-beaf-329e604bb779.jpg,
/yzx/20220909/762-3-1dc1a42c-13ce-4d41-bf1d-bfbaec820ded.jpg,
/yzx/20220909/762-5-2c0b48d2-c8ac-4cae-b20a-4160da361f91.jpg,
/yzx/20220909/762-4-d003e5cf-e07f-4421-964a-6d239943a7f9.jpg,
/yzx/20220909/762-3-33072a9b-4a84-44a2-9074-eea784bc97de.jpg,
/yzx/20220909/762-5-fdc96fca-410c-4554-afa5-033415f6fa1d.jpg,
/yzx/20220909/762-4-dd371fe9-f675-4f1e-b34e-7047a3d6f05e.jpg,
/yzx/20220909/762-3-d4c97fd7-23c7-42c4-b829-911e2b485192.jpg,
/yzx/20220909/762-5-a27d73a2-2ac4-4faf-8d74-8fad
显示了这几条,而且还存在不完整的一条数据!!
总是感觉这个框里面的长度给限定了,但是又不知道哪限定了!
有问题找百度!!!
果然 1024
每年的10月24是程序员的节日!!!
然后…就改呗
搞定!