Afan Pasalic Increase for 1 using REPLACE function
Mar 18, 2011; 17:24
Afan Pasalic
Increase for 1 using REPLACE function
I have to increase 'no_of_visits' for 1. Using UPDATE function is easy:
update visits set no_of_visits=no_of_visits+1 where visitor_id=123
but, how it should be (if possible at all) if I want to use REPLACE function?
I tried something similar
replace into visitors values ($visitor_id, (no_of_visits+1))
but it doesn't work?!?
Thanks.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Mar 18
S?ndor Hal?sz Re: Increase for 1 using REPLACE function
Mar 18, 2011; 17:53
S?ndor Hal?sz
Re: Increase for 1 using REPLACE function
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!