Topics tagged sql

Topic	Replies	Views	Activity
How to find out the most active wishlist users in your store? Administration wishlist , customer , report , sql	1	124	October 23, 2020
How to find out how much customers uses the product comparison feature? Administration product-comparison , sql , report	1	150	October 23, 2020
How to find out how much customers uses wishlists? Administration wishlist , customer , sql , report	1	118	October 23, 2020
How to execute the COUNT() SQL function Database database , sql , db-count	2	10447	December 1, 2018
How to change the root URL (move Magento 2 to another domain)? Administration sql , url , env.php , app-etc , base-url	4	33570	January 3, 2017
How to programmatically check whether a database table contains a specified column? Database db-column , db-table , sql	1	1308	November 4, 2016
How to rename a database column? Database db-alter-table , db-column , database , db-table , sql	1	2239	November 4, 2016
How to change (modify) a column definition for a database table Database database , sql , db-table , db-alter-table , db-column	1	17787	January 26, 2016
How to programmatically execute the «SHOW TABLE STATUS» SQL statement for a database table Database database , show-table-status , sql	1	2123	January 26, 2016
How to alter a database table? Database database , sql , db-table , db-alter-table	1	2598	January 26, 2016
How to delete (drop) a foreign key from a database table Database database , sql , db-table , db-alter-table , foreign-key	1	3685	January 26, 2016
How to add a foreign key to a database table Database database , sql , db-table , db-alter-table , foreign-key	1	9831	January 26, 2016
How to delete (drop) an index from a database table Database database , sql , db-table , db-alter-table , db-index	1	5586	January 26, 2016
How to add an index to a database table Database database , sql , db-table , db-alter-table , db-index	1	9732	January 26, 2016
How to rename a database table Database database , sql , db-table , db-alter-table	1	2767	January 26, 2016
How to delete (drop) a column from a database table? Database database , sql , db-table , db-alter-table , db-column	2	5953	November 4, 2016
How to add a column to a database table? Database database , sql , db-table , db-alter-table , db-column	2	9542	November 4, 2016
How to reset the «Secure Base URL for Static View Files» option value by an SQL query? Administration static-content , base-url , url , configuration , sql , secure-url , https , ssl , security	1	3512	March 25, 2016
How to reset the «Secure Base URL for User Media Files» option value by an SQL query? Administration media , base-url , url , configuration , sql , secure-url , https , ssl , security	1	1721	March 25, 2016
A product list CMS widget rendering failed: «Error filtering template: Unknown column 'e.category_ids' in 'where clause'» (and my fix) Issues sql , cms-widget , bug , attribute , product-attribute , attribute-category_ids , bug-fix , rendering	4	3294	May 16, 2016
How to programmatically check whether a customer is new or returning? Customer sales , customer , db-select , database , sql , order-state , order-state-complete , order-state-processing	0	954	May 13, 2016
How does \Magento\Framework\DB\Adapter\Pdo\Mysql::getCheckSql() work? Database database , sql	0	1645	April 29, 2016
How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::addAttributeGrouping() work? Database database , eav , eav-collection , collection , db-group , sql , db-collection	0	912	April 29, 2016
How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::getSelectCountSql() work? Database sql , db-count , collection , database , db-collection , eav , eav-collection , attribute , attribute-collection	0	1210	April 29, 2016
How is a frontend full-text search implemented? Development db-collection , product-collection , full-text-search , search , sql , search-synonyms , search-criteria-builder	0	16838	April 2, 2016
How to decrease a Magento 2 database size after a long-term intensive usage? Administration sql , database	0	1324	July 16, 2015
Mage2.PRO extensions versioning has been changed on 2016-04-12 Mage2.PRO sql , version , database , module	0	1467	April 12, 2016
How does the \Magento\Rule\Model\Condition\Sql\Builder::_joinTablesToCollection() work? Development catalog-rule , sql	1	1741	April 7, 2016
How to reset (make empty) the «Base URL for User Media Files» option value by an SQL query? Administration sql , configuration , url , base-url , media	1	1186	March 25, 2016
How to reset (make empty) the «Base URL for Static View Files» option value by an SQL query? Administration sql , configuration , url , base-url , static-content	1	1729	March 25, 2016