我Employee在SQLite数据库中有一个表。其主键是GUID类型的“ ID”。我尝试使用以下查询找到id= guid的记录'a8828ddf-ef22-4d36-935a-1c66ae86ebb3',但没有运气:
Employee
id
'a8828ddf-ef22-4d36-935a-1c66ae86ebb3'
SELECT * FROM Employee WHERE Employee.Id = 'a8828ddf-ef22-4d36-935a-1c66ae86ebb3'
谁能告诉我该如何编写查询?
谢谢,
GUID可能被存储为二进制blob。尝试:
SELECT * FROM Employee WHERE Employee.Id = X'a8828ddfef224d36935a1c66ae86ebb3';