MySql : How to update column of table by checking for multiple fields in where clause? -


i tried way

update message set status='accepted' tid=' ' , ltime=' ' , ldate=' '; 

but shows error in syntax.

my row uniquely identified through these 3 fields.

since status reserved keyword

try this

update message  set `status`='accepted'  tid=' ' , ltime=' ' , ldate=' '; 

keywords , reserved words in mysql


Comments