Topics tagged sql

Topic	Replies	Views	Activity
How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::addAttributeGrouping() work? Database db-group , sql , database , eav , collection , eav-collection , db-collection	0	1239	April 29, 2016
How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::getSelectCountSql() work? Database sql , database , eav , db-count , attribute , collection , eav-collection , db-collection , attribute-collection	0	1628	April 29, 2016
How is a frontend full-text search implemented? Development sql , search-synonyms , product-collection , full-text-search , db-collection , search , search-criteria-builder	0	22169	April 2, 2016
Mage2.PRO extensions versioning has been changed on 2016-04-12 Questions sql , database , module , version	0	1786	April 12, 2016
How does the \Magento\Rule\Model\Condition\Sql\Builder::_joinTablesToCollection() work? Development sql , catalog-rule	1	2520	April 7, 2016
How to reset (make empty) the «Base URL for User Media Files» option value by an SQL query? Administration sql , media , base-url , configuration , url	1	1642	March 25, 2016
How to reset (make empty) the «Base URL for Static View Files» option value by an SQL query? Administration static-content , sql , base-url , configuration , url	1	2452	March 25, 2016
«Unknown column 'base_grand_total'» while executing «INSERT INTO `sales_invoice_grid`» Issues db-column , backend , sql , db-index , bug , invoice	1	1662	March 7, 2016
How to get the SQL expression for a collection? Database sql , collection	1	14935	February 4, 2016
How to get the SQL expression for a \Magento\Framework\DB\Select or \Zend_Db_Select instance Database sql , db-select	1	3918	February 4, 2016
How does a database transaction work? Database sql , database , db-transaction	1	3617	January 27, 2016
How to fix the «DDL statements are not allowed in transactions» failure with the addCommitCallback() Database sql , database , db-transaction	1	11397	January 27, 2016
The \Magento\Quote\Setup\UpgradeSchema::upgrade() method can be simplified by using the modifyColumn() instead of changeColumn() method of the \Magento\Framework\DB\Adapter\AdapterInterface because the column need not be renamed Issues db-column , sql , db-alter-table , database , improvement , db-table , code-quality	1	1366	January 26, 2016
How to get the maximum value of a database table's column programmatically Database sql , database	1	4163	January 26, 2016
How to get the next autoincrement id for a database table programmatically Database sql , database , db-table-increment	1	4586	January 11, 2016
Propose to move the \Magento\ImportExport\Model\ResourceModel\Helper::getNextAutoincrement() method to the \Magento\Framework\DB\Adapter\Pdo\Mysql class and to the \Magento\Framework\DB\Adapter\AdapterInterface Issues sql , database , db-table-increment , mysql , improvement , code-quality	1	1253	January 11, 2016