mysql判断语句语法问题!!!
尝试下,对MYSQL接触不多.给时间加##
inser必伯岩育也三搞位沉t into yqa (datetime) values(cast('#2008-6-1 0:0:0#' as d案危粉先老减更本态火理atetime)) where not EXISTS (select * from yqa w来自here a = '2345')
mysql先更新马上查询的语句
select * from a inner join b on if(countryid is null,countryid+1,countryid)=b.cityid
MYSQL if 语句查询两个条件或任意一个条件都可以的
应该这样写吧:
SELECT COUNT(*) FROM tougao_record WHERE accept_company_id=100 AND channel_type=1 AND check_status=6