Development   Database


How to execute the COUNT() SQL function (3)
How to dump a store's database schema for convenient reading and comparison in tools like Araxis Merge? (2)
How to decrypt a password from a store's configuration? (1)
How to get the database name programmatically (2)
How to get the MySQL server's version with PHP? (1)
How to programmatically check whether a database table contains a specified column? (2)
How to rename a database column? (2)
How to change (modify) a column definition for a database table (2)
How to programmatically execute the «SHOW TABLE STATUS» SQL statement for a database table (2)
How to alter a database table? (2)
How to delete (drop) a foreign key from a database table (2)
How to add a foreign key to a database table (2)
How to delete (drop) an index from a database table (2)
How to add an index to a database table (2)
How to rename a database table (2)
How to delete (drop) a column from a database table? (3)
How to add a column to a database table? (3)
How does \Zend_Db_Select::group() work? (1)
How does \Magento\Framework\DB\Adapter\Pdo\Mysql::getCheckSql() work? (1)
How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::addAttributeGrouping() work? (1)
How does \Magento\Framework\Data\Collection\AbstractDb::getSize() work? (1)
How does \Zend_Db_Select::reset() work? (1)
How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::getSelectCountSql() work? (1)
How does \Magento\Framework\Data\Collection\AbstractDb::getSelectCountSql() work? (1)
How does \Zend_Db_Select::getPart() work? (1)
How does \Magento\Framework\Data\Collection\AbstractDb::_renderFilters() work? (1)
How does \Magento\Framework\Data\Collection\AbstractDb::_renderFiltersBefore() work? (1)
How does \Magento/Framework/DB/Transaction::_commitTransaction() work? (1)
How does \Magento/Framework/DB/Transaction::_startTransaction() work? (1)
How does \Magento\Framework\EntityManager\Db\ReadRow::execute() work? (2)