We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

How to start a new \Phalcon\Db\Adapter\Pdo\Mysql() connection from the existing connections in INVO project .

I am using INVO as skeleton for my project....and i want to create a new table in the midway using \Phalcon\Db\Adapter\Pdo\Mysql() from the existing db connection....How can i do this?

edited Dec '16

You can execute native SQL queries like so:

$this->db->execute("
CREATE TABLE tbl
    id INT, INDEX USING BTREE (id))
ENGINE = MEMORY;");