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

node.js - How to mock a third-party api calls in the backend -

node.js - Why do I get "SOCKS connection failed. Connection not allowed by ruleset" for some .onion sites? -

matlab - 0-by-1 sym - What do I need to change in order to get proper symbolic results? -