Hello, I was looking for ways to improve my work with dynamic mysql database/table names. And I found prepare method in Phalcon\Db\Adapter\Pdo. Also I've read somewhere on forum that phalcon prepares sql statements implicitly.
So my first question: Why and when do we need to explicitely use prepare method?
And my second question: Is there a way to utilize phalcon prepared statements to achieve something like this:
SET @id := '47'; SET @table := concat(@id,'_2013_2014_voucher'); set @qry1:= concat('select * from ',@table); prepare stmt from @qry1 ; execute stmt ;
? (this is mysql implementation of dynamic table names usage from the stackoverflow post).