画框的那段sql语句该怎么写啊,写了几次都不对想写的是:数据库Audit表中State字段等于通过或待审核时(我原来写的是Select * from Audit where State in (通过,待审核) 但是这样会报错)
æçç解æ¯ï¼æ³å¤ææä¸ä¸ªæ³¨åç¨æ·IDæ¯å¦å·²ç»æ³¨åè¿äºï¼å¯¹åï¼æ以è¿æ¡SQLè¯å¥åºè¯¥è¦æ两个æ¡ä»¶æè¡ï¼è¯çæ¹æä¸é¢è¿æ ·ï¼
Select * from Audit where State=(State='éè¿' OR State='å¾ å®¡æ ¸') AND teachernumber=@teachernumber
å¦æåªæ¯å¤æè®°å½æ¯å¦åå¨çè¯ï¼å»ºè®®ä¿®æ¹æä¸é¢çè¯å¥ï¼æçå¯è½ä¼é«ä¸ç¹å¦ã
Select count(1) from Audit where State=(State='éè¿' OR State='å¾ å®¡æ ¸') AND teachernumber=@teachernumber
Select * from Audit where State=(State='éè¿' OR State='å¾ å®¡æ ¸') AND teachernumber=@teachernumber
å¦æåªæ¯å¤æè®°å½æ¯å¦åå¨çè¯ï¼å»ºè®®ä¿®æ¹æä¸é¢çè¯å¥ï¼æçå¯è½ä¼é«ä¸ç¹å¦ã
Select count(1) from Audit where State=(State='éè¿' OR State='å¾ å®¡æ ¸') AND teachernumber=@teachernumber
温馨提示:答案为网友推荐,仅供参考
第1个回答 2018-11-28
你的逻辑错了吧,你要查用户是否已经注册,不是应该查你的表中是否有对应的用户名存在么?