Topics tagged sql

Topic	Replies	Views	Activity
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	1514	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	2307	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	1586	March 7, 2016
How to get the SQL expression for a collection? Database sql , collection	1	14345	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	3470	February 4, 2016
How does a database transaction work? Database sql , database , db-transaction	1	3367	January 27, 2016
How to fix the «DDL statements are not allowed in transactions» failure with the addCommitCallback() Database sql , database , db-transaction	1	10424	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	1269	January 26, 2016
How to get the maximum value of a database table's column programmatically Database sql , database	1	3818	January 26, 2016
How to get the next autoincrement id for a database table programmatically Database sql , database , db-table-increment	1	4317	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	1145	January 11, 2016