UPDATE `tbl_employee` SET isleaved ='1' AND leaveDate=NOW()表结构说明
isLeaved varchar length=1
leaveDate varchar length=19
请问上述sql语句,为什么 更新不成功呢,简直疯掉!
isLeaved varchar length=1
leaveDate varchar length=19
请问上述sql语句,为什么 更新不成功呢,简直疯掉!
UPDATE `tbl_employee` SET isleaved ='1' AND leaveDate=
date_format(NOW(),'%Y-%m-%d')
Transfer Time : 0.002 sec
Total Time : 0.003 sec