MYSQL
MYSQL
Constant for MYSQL database type
SQL class
$db : \Pop\Db\Adapter\AdapterInterface
Database object
$clause : \Pop\Db\Sql\AbstractSql
SQL clause object
__construct(\Pop\Db\Adapter\AdapterInterface $db, mixed $table = null, string $alias = null) : \Pop\Db\Sql
Constructor
Instantiate the SQL object.
\Pop\Db\Adapter\AdapterInterface | $db | |
mixed | $table | |
string | $alias |
setDb(\Pop\Db\Adapter\AdapterInterface $db) : \Pop\Db\Sql
Set the database adapter object
\Pop\Db\Adapter\AdapterInterface | $db |
setQuoteId(string $type = \Pop\Db\Sql::NO_QUOTE) : \Pop\Db\Sql
Set the quote ID type
string | $type |
setTable(mixed $table = null) : \Pop\Db\Sql
Set current table to operate on.
mixed | $table |
from(mixed $table = null) : \Pop\Db\Sql
Set current table to operate on. (alias for setTable)
mixed | $table |
into(mixed $table = null) : \Pop\Db\Sql
Set current table to operate on. (alias for setTable)
mixed | $table |
setAlias(string $alias = null) : \Pop\Db\Sql
Set alias name
string | $alias |
getDb() : \Pop\Db\Adapter\AdapterInterface
Get the current database adapter object.
db() : \Pop\Db\Adapter\AdapterInterface
Get the current database adapter object (alias method.)
select(mixed $columns = null) : \Pop\Db\Sql\Select
Create a select statement
mixed | $columns |
insert(mixed $columns = null) : \Pop\Db\Sql\Insert
Create a insert statement
mixed | $columns |
update(mixed $columns = null) : \Pop\Db\Sql\Update
Create a update statement
mixed | $columns |
delete(mixed $delete = null) : \Pop\Db\Sql\Update
Create a delete statement
mixed | $delete |