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	1229	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	1621	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	22156	April 2, 2016
Mage2.PRO extensions versioning has been changed on 2016-04-12 Questions sql , database , module , version	0	1783	April 12, 2016
How does the \Magento\Rule\Model\Condition\Sql\Builder::_joinTablesToCollection() work? Development sql , catalog-rule	1	2512	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	1630	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	2445	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	1651	March 7, 2016
How to get the SQL expression for a collection? Database sql , collection	1	14920	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	3860	February 4, 2016
How does a database transaction work? Database sql , database , db-transaction	1	3605	January 27, 2016
How to fix the «DDL statements are not allowed in transactions» failure with the addCommitCallback() Database sql , database , db-transaction	1	11364	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	1356	January 26, 2016
How to get the maximum value of a database table's column programmatically Database sql , database	1	4153	January 26, 2016
How to get the next autoincrement id for a database table programmatically Database sql , database , db-table-increment	1	4578	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	1245	January 11, 2016