Top.Mail.Ru
? ?
daemon face

brewbuilder, posts by tag: sql - LiveJournal

Entries by tag: sql

MySQL can do the next
daemon face
Imagebrewbuilder
update AWS_SEARCH_SESSION,AWS_SEARCH_TERM,AWS_SEARCH_TERM_COUNTER 
set
  AWS_SEARCH_TERM_COUNTER.counter=AWS_SEARCH_TERM_COUNTER.counter+:inc, 
  AWS_SEARCH_SESSION.end=now() 
where AWS_SEARCH_TERM_COUNTER.searchTermId=AWS_SEARCH_TERM.id and 
  AWS_SEARCH_TERM.term=:term and AWS_SEARCH_SESSION.id=:sessionId 
              and 
  AWS_SEARCH_TERM_COUNTER.userId=:uid and 
  AWS_SEARCH_SESSION.id=AWS_SEARCH_TERM_COUNTER.sessionId and 
  AWS_SEARCH_TERM_COUNTER.refinementType=:refinementType
Tags:

Image