[SQL] update case_history set ID=1,petID=2,doctorID=10,condition='gaga',med_date='wewe' where ID=1
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition='gaga',med_date='wewe' where ID=1' at line 1
这是我的错误,怎么改
condition 关键字 , 用`` 标记。
UPDATED:
update case_history set ID
=1,petID
=2,doctorID
=10,condition
='gaga',med_date
='wewe' where ID=1;
UPDATE case_history SET condition
=111 WHERE id = 1;