Use mysql user variables in Zend Framework 2

Question

I want to run a mysql query including variables. A simple version of this looks like that:

$sql = "UPDATE mytable,
(SELECT @counter := IFNULL(@counter,0) + 1 as new_value,
        mycolumn
 FROM othertable
 ORDER BY mycolumn) i
SET mytable.counter_column = i.new_value
WHERE i.mycolumn = mytable.mycolumn";

$this
  ->getSlaveSql()
  ->getAdapter()
  ->getDriver()->getConnection()->execute($sql);

But the result value is always 1. If I run the query directly, I have a correct line of numbers. I think, the variables will be unset bei Zend, so that @counter is 0 on every row.

check this one out: http://stackoverflow.com/questions/12948782/mysql-query-with-mysql-variable-not-working-in-zend-framework-1 — skarist, Jul 31 '14 at 20:56
No, because it is already one query. I think I should use another method for that maybe. — Stefan Wienströer, Aug 02 '14 at 22:45

score 0 · Accepted Answer · answered Aug 04 '14 at 18:51

0

I used a stored procedure for this now.

answered Aug 04 '14 at 18:51

Stefan Wienströer

44
9

Use mysql user variables in Zend Framework 2

1 Answers1