Development   Database


Topic Replies Views Activity
How to execute the COUNT() SQL function
database ,  sql ,  db-count
2 13203 December 1, 2018
How to dump a store's database schema for convenient reading and comparison in tools like Araxis Merge?
mysql
1 675 November 10, 2018
How to decrypt a password from a store's configuration?
configuration ,  encryption
0 1915 November 7, 2018
How to get the database name programmatically
database
1 2864 March 13, 2018
How to get the MySQL server's version with PHP?
mysql ,  version
0 732 December 23, 2016
How to programmatically check whether a database table contains a specified column?
db-column ,  db-table ,  sql
1 1623 November 4, 2016
How to rename a database column?
db-alter-table ,  db-column ,  database ,  db-table ,  sql
1 2663 November 4, 2016
How to change (modify) a column definition for a database table
database ,  sql ,  db-table ,  db-alter-table ,  db-column
1 20219 January 26, 2016
How to programmatically execute the «SHOW TABLE STATUS» SQL statement for a database table
database ,  show-table-status ,  sql
1 2559 January 26, 2016
How to alter a database table?
database ,  sql ,  db-table ,  db-alter-table
1 2944 January 26, 2016
How to delete (drop) a foreign key from a database table
database ,  sql ,  db-table ,  db-alter-table ,  foreign-key
1 4573 January 26, 2016
How to add a foreign key to a database table
database ,  sql ,  db-table ,  db-alter-table ,  foreign-key
1 10699 January 26, 2016
How to delete (drop) an index from a database table
database ,  sql ,  db-table ,  db-alter-table ,  db-index
1 6694 January 26, 2016
How to add an index to a database table
database ,  sql ,  db-table ,  db-alter-table ,  db-index
1 11653 January 26, 2016
How to rename a database table
database ,  sql ,  db-table ,  db-alter-table
1 3121 January 26, 2016
How to delete (drop) a column from a database table?
database ,  sql ,  db-table ,  db-alter-table ,  db-column
2 6691 November 4, 2016
How to add a column to a database table?
database ,  sql ,  db-table ,  db-alter-table ,  db-column
2 10465 November 4, 2016
How does \Zend_Db_Select::group() work?
zend-framework ,  zend-framework-1 ,  db-select ,  database ,  db-group
0 1045 April 29, 2016
How does \Magento\Framework\DB\Adapter\Pdo\Mysql::getCheckSql() work?
database ,  sql
0 2014 April 29, 2016
How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::addAttributeGrouping() work?
database ,  eav ,  eav-collection ,  collection ,  db-group ,  sql ,  db-collection
0 1056 April 29, 2016
How does \Magento\Framework\Data\Collection\AbstractDb::getSize() work?
collection ,  database ,  db-collection ,  db-count
0 1171 April 29, 2016
How does \Zend_Db_Select::reset() work?
zend-framework-1 ,  zend-framework ,  db-select ,  database
0 4225 April 29, 2016
How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::getSelectCountSql() work?
sql ,  db-count ,  collection ,  database ,  db-collection ,  eav ,  eav-collection ,  attribute ,  attribute-collection
0 1434 April 29, 2016
How does \Magento\Framework\Data\Collection\AbstractDb::getSelectCountSql() work?
database ,  collection ,  db-collection ,  db-count
0 1352 April 29, 2016
How does \Zend_Db_Select::getPart() work?
database ,  zend-framework ,  zend-framework-1 ,  db-select
0 1874 April 29, 2016
How does \Magento\Framework\Data\Collection\AbstractDb::_renderFilters() work?
collection ,  db-collection ,  database ,  collection-filter
0 1037 April 29, 2016
How does \Magento\Framework\Data\Collection\AbstractDb::_renderFiltersBefore() work?
database ,  collection ,  db-collection ,  collection-filter
0 1085 April 29, 2016
How does \Magento/Framework/DB/Transaction::_commitTransaction() work?
database ,  db-transaction
0 911 April 26, 2016
How does \Magento/Framework/DB/Transaction::_startTransaction() work?
db-transaction ,  database
0 1235 April 26, 2016
How does \Magento\Framework\EntityManager\Db\ReadRow::execute() work?
entity-manager ,  eav ,  database ,  product-retrieving ,  product
1 843 April 25, 2016