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
Post a Comment