How to generate the following query with update fn

[Jonathan M.]

Hello,

I was wondering if it's possible to do the following query using the update fn with a MySQL server

UPDATE table SET column = column + 1;

Thank you for any replies

Jonathan 

[Dennis Roberts]

The only way that I've been able to find to do it so far is to use (raw):

(sql-only (update :foo (set-fields {:bar (raw "\"bar\" + 1")})))

There may be a better way to do it, but I haven't found one yet.

Dennis

--
You received this message because you are subscribed to the Google Groups "Korma" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlkorma+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Jonathan M.]

Thanks Dennis. I was using exec-raw up until now, good to know for the alternative thought. 

If there is an ever better way I would love to hear about it 

[Michael Pheasant]

Is there any way to find out how many rows were changed by an update querry?

As far as I can see update always returns nil, regardless of how many rows were updated.

m

[Ryan T.]

Good question...Unless there is a better way via the framework you can always use mysql_affected_rows with exec-raw

Some clarification would be really nice for basic things such as these.

--
You received this message because you are subscribed to a topic in the Google Groups "Korma" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sqlkorma/ecPL4LMmFpM/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to sqlkorma+u...@googlegroups.com.