如何仅在MySQL中使用Alter和Select在表中显示数据子集？
我有一个像这样的MySQL表：
TagName, DateTime, Value
'SG_QRA_SGTC_0013.PV_Top_Temp', '2022-07-05 11:27:43.7810000', '86.4'
'SG_QRA_SGTC_0013.PV_Bot_Temp', '2022-07-05 11:27:43.7030000', '25.1'
'SG_QRA_SGHAST_0065.PV_HUMIDITY', '2022-07-05 11:27:43.6890000', '85.11'
'SG_QRA_SGHAST_0066.PV_HUMIDITY', '2022-07-05 11:27:43.6890000', '38.48'
我想做的就是更改表仅永久显示此表，但我现在无法这样做：
TagName, DateTime, Value
'SG_QRA_SGTC_0013.PV_Top_Temp', '2022-07-05 11:27:43.7810000', '86.4'
'SG_QRA_SGTC_0013.PV_Bot_Temp', '2022-07-05 11:27:43.7030000', '25.1'
有了此查询：
SELECT * FROM testingintern WHERE TagName like '%Top%' OR TagName like '%Bot% AND TIME(DateTime) = '11:27:43';
任何帮助都会感谢您！
I have a MySQL table like this:
TagName, DateTime, Value
'SG_QRA_SGTC_0013.PV_Top_Temp', '2022-07-05 11:27:43.7810000', '86.4'
'SG_QRA_SGTC_0013.PV_Bot_Temp', '2022-07-05 11:27:43.7030000', '25.1'
'SG_QRA_SGHAST_0065.PV_HUMIDITY', '2022-07-05 11:27:43.6890000', '85.11'
'SG_QRA_SGHAST_0066.PV_HUMIDITY', '2022-07-05 11:27:43.6890000', '38.48'
What I want to do is to to alter the table to only show this permanently but i am unable to do so now:
TagName, DateTime, Value
'SG_QRA_SGTC_0013.PV_Top_Temp', '2022-07-05 11:27:43.7810000', '86.4'
'SG_QRA_SGTC_0013.PV_Bot_Temp', '2022-07-05 11:27:43.7030000', '25.1'
with this query:
SELECT * FROM testingintern WHERE TagName like '%Top%' OR TagName like '%Bot% AND TIME(DateTime) = '11:27:43';
Any help is appreciated thank you!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
从您发布的查询中，我看到的问题是您忘记了“
'％bot％”，因此它认为您需要包含％bot％和时间（dateTime）的东西= '11：27：43'，而不是％bot％。使其'％bot％'应该修复或至少使您朝正确的方向前进From the query you posted, the problem I see with it is that you forgot a ' after
'%bot%, so it thinks you want something that contains%Bot% AND TIME(DateTime) = '11:27:43'instead of just%bot%. Making it'%bot%'should fix or at least get you going in the right direction