MySql: count+1 in a SELECT query

Question

How i put an update in a SELECT-query at once. I wish to count a field from the SELECTed row.

SELECT * FROM `_server` order by hits asc LIMIT 1 (update `_server` set `hits`=hits+1)

Not sure what you mean dazzafact. Is the goal of selecting the hits to display it to the user first? If so, @Siyual is right. Otherwise, you might be implying something like this: http://stackoverflow.com/questions/1262786/mysql-update-query-based-on-select-query — Greg Viers, Sep 28 '15 at 15:30
Which rows you want to update? There is no `WHERE` condition in your query. — Hotdin Gurning, Sep 28 '15 at 15:30

score 1 · Answer 1 · answered Sep 28 '15 at 15:30

1

You can use order by and limit in update:

update `_server`
    set hits = hits + 1
    order by hits asc
    limit 1;

answered Sep 28 '15 at 15:30

Gordon Linoff

i cant get the query "while ($row = $res->fetch_row())" – dazzafact Sep 28 '15 at 15:54
I have no idea what your comment is supposed to convey. For instance, your question says nothing about application code. – Gordon Linoff Sep 28 '15 at 23:25

1 Answers1