请帮助mysql更新查询条件不起作用 [英] Please help mysql update query with condition is not working

问题描述

我有一个mysql表，我需要在没有条件的情况下更新带有2个值的tokeno



请帮我纠正代码



我尝试过：



UPDATE doctorshistory SET`tandreno` ='2'在哪里（'doctorid` ='5'和'date'='2016/02/02'和'departmentid'='107'）;



当我跑查询mysql显示更新为0行？

解决方案

引用 - 删除它们。

尝试：

< pre lang =SQL> 更新 doctorshistory SET tokenno = ' 2' WHERE （doctorid = 5 AND date = ' 13/02 / 2016' AND departmentid = 107）;

I have a mysql table and i need to update tokeno with 2 value when a give no of condition

please help me to correct the code

What I have tried:

UPDATE doctorshistory SET `tokenno`='2' WHERE (`doctorid`= '5' AND 'date'='13/02/2016' AND 'departmentid'='107');

when i run the query mysql shows updated with 0 rows ?

解决方案

Quotes - remove them.
Try:

UPDATE doctorshistory SET tokenno='2' WHERE (doctorid= 5 AND date='13/02/2016' AND departmentid=107);

这篇关于请帮助mysql更新查询条件不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！