MySQL- Select and Update at the same time -


i have query

select * outbox status=0 ; 

then need update selected records status should equal 1

i.e (update outbox(selected records select query) set status =1 )

any ?

you can that, outbox table:

update outbox set status = 1 status = 0 

Comments

Popular posts from this blog

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

java - Could not locate OpenAL library -

sorting - opencl Bitonic sort with 64 bits keys -