Development   Database


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