编写“噪声检测系统”的服务器端程序，若要读取sensorlog数据表中sensorid字段为1的所有记录，其中sensorid字段的数据类型为字符型，下列执行的命令语句恰当的是( )
A、SELECT all FROM sensorlog WHERE sensorid=1
B、SELECT all FROM sensorlog WHERE sensorid= "1"
C、SELECT * FROM sensorlog WHERE sensorid= "1"
D、SELECT * FROM sensorlog WHERE sensorid=l
