Topics tagged sql

Topic	Replies	Views	Activity
How is a frontend full-text search implemented? Development sql , search-synonyms , product-collection , full-text-search , db-collection , search , search-criteria-builder	0	22146	April 2, 2016
Mage2.PRO extensions versioning has been changed on 2016-04-12 Questions sql , database , module , version	0	1782	April 12, 2016
How does the \Magento\Rule\Model\Condition\Sql\Builder::_joinTablesToCollection() work? Development sql , catalog-rule	1	2510	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	1628	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	2444	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	1650	March 7, 2016
How to get the SQL expression for a collection? Database sql , collection	1	14910	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	3851	February 4, 2016
How does a database transaction work? Database sql , database , db-transaction	1	3595	January 27, 2016
How to fix the «DDL statements are not allowed in transactions» failure with the addCommitCallback() Database sql , database , db-transaction	1	11346	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	1353	January 26, 2016
How to get the maximum value of a database table's column programmatically Database sql , database	1	4152	January 26, 2016
How to get the next autoincrement id for a database table programmatically Database sql , database , db-table-increment	1	4576	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