下面的查询返回我查找的内容。
SELECT * from meetings where meetings.date = '2018-03-12';
然而,下面这一条却给了我
“where子句”中的“2018”一栏
SELECT roomNumber
FROM rooms
WHERE NOT EXISTS
( SELECT *
FROM meetings
WHERE rooms.roomNumber = meetings.room
AND meetings.date = ‘2018-03-12’ );
我尝试了2018-03-12没有单引号,而且它工作。但是,这并不