sql select query显示列标题,而不是列中的数据

jm81lzqq  于 2021-06-20  发布在  Mysql
关注(0)|答案(2)|浏览(403)
SELECT Week, Date, Male, Female, Children, Total, No_Of_Meetings, Total_Attendance, Visitors, New_Cells_Created, Cells_Closed, No_Of_Leaders, Members_Who_Have_Joined_Cell, Decisions_Made_For_Christ, Pers_Established_In_Local_church, Bible_Study_Groups, Bible_Study_Leaders, Endorsed_By, Designation, contact FROM `Week_Report` WHERE Cellname = 'John'

使用

SELECT * FROM `Week_Report` WHERE Cellname = 'Bibiani'

引用cellname列标题

oyt4ldly

oyt4ldly1#

在记录的前面和结尾都有空格,因此sql找不到“bibiani”,因为实际记录类似于“bibibiani”

j13ufse2

j13ufse22#

如果您只看到作为查询结果的标题列,这意味着此查询没有任何结果。

相关问题