abstract public addColumn (mixed $tableName, mixed $schemaName, Phalcon\Db\ColumnInterface $column) ...

Source on GitHub Methods abstract public fetchOne (mixed $sqlQuery, [mixed $fetchMode], [mixed $placeholders]) ... abstract public fetchAll (mixed $sqlQuery, [mixed $fetchMode], [mixed $placeholders]) ... abstract public insert (mixed $table, array $values, [mixed $fields], [mixed $dataTypes]) ... abstract public update (mixed $table, mixed $fields, mixed $values, [mixed $whereCondition], [mixed $dataTypes]) ... abstract public delete (mixed $table, [mixed $whereCondition], [mixed $placeholders

public viewExists (mixed $viewName, [mixed $schemaName]) Generates SQL checking for the existence of a schema.view var_dump($connection->viewExists("active_users", "posts"));

public useExplicitIdValue () Check whether the database system requires an explicit value for identity columns

public boolean updateAsDict (string $table, array $data, [string $whereCondition], [array $dataTypes]) Updates data on a table using custom RBDM SQL syntax Another, more convenient syntax //Updating existing robot $success = $connection->updateAsDict( "robots", array( "name" => "New Astro Boy" ), "id = 101" ); //Next SQL sentence is sent to the database system UPDATE `robots` SET `name` = "Astro boy" WHERE id = 101

public boolean update (string | array $table, array $fields, array $values, [string | array $whereCondition], [array $dataTypes]) Updates data on a table using custom RBDM SQL syntax //Updating existing robot $success = $connection->update( "robots", array("name"), array("New Astro Boy"), "id = 101" ); //Next SQL sentence is sent to the database system UPDATE `robots` SET `name` = "Astro boy" WHERE id = 101 //Updating existing robot with array condition and $dataTypes $success =

public tableOptions (mixed $tableName, [mixed $schemaName]) Gets creation options from a table print_r($connection->tableOptions('robots'));

public tableExists (mixed $tableName, [mixed $schemaName]) Generates SQL checking for the existence of a schema.table var_dump($connection->tableExists("blog", "posts"));

public supportSequences () Check whether the database system requires a sequence to produce auto-numeric values

public sharedLock (mixed $sqlQuery) Returns a SQL modified with a LOCK IN SHARE MODE clause