abstract public addForeignKey (mixed $tableName, mixed $schemaName, Phalcon\Db\ReferenceInterface $reference) ...

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

abstract public affectedRows () ...

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

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

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

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

public setEventsManager (Phalcon\Events\ManagerInterface $eventsManager) Sets the event manager