Database

Topic	Replies	Views	Activity
How to execute the COUNT() SQL function database , sql , db-count	2	13780	December 1, 2018
How to dump a store's database schema for convenient reading and comparison in tools like Araxis Merge? mysql	1	718	November 10, 2018
How to decrypt a password from a store's configuration? configuration , encryption	0	2248	November 7, 2018
How to get the database name programmatically database	1	2977	March 13, 2018
How to get the MySQL server's version with PHP? mysql , version	0	760	December 23, 2016
How to programmatically check whether a database table contains a specified column? db-column , db-table , sql	1	1677	November 4, 2016
How to rename a database column? db-alter-table , db-column , database , db-table , sql	1	2752	November 4, 2016
How to change (modify) a column definition for a database table database , sql , db-table , db-alter-table , db-column	1	20596	January 26, 2016
How to programmatically execute the «SHOW TABLE STATUS» SQL statement for a database table database , show-table-status , sql	1	2690	January 26, 2016
How to alter a database table? database , sql , db-table , db-alter-table	1	3021	January 26, 2016
How to delete (drop) a foreign key from a database table database , sql , db-table , db-alter-table , foreign-key	1	4768	January 26, 2016
How to add a foreign key to a database table database , sql , db-table , db-alter-table , foreign-key	1	10890	January 26, 2016
How to delete (drop) an index from a database table database , sql , db-table , db-alter-table , db-index	1	6958	January 26, 2016
How to add an index to a database table database , sql , db-table , db-alter-table , db-index	1	11943	January 26, 2016
How to rename a database table database , sql , db-table , db-alter-table	1	3193	January 26, 2016
How to delete (drop) a column from a database table? database , sql , db-table , db-alter-table , db-column	2	6837	November 4, 2016
How to add a column to a database table? database , sql , db-table , db-alter-table , db-column	2	10589	November 4, 2016
How does \Zend_Db_Select::group() work? zend-framework , zend-framework-1 , db-select , database , db-group	0	1087	April 29, 2016
How does \Magento\Framework\DB\Adapter\Pdo\Mysql::getCheckSql() work? database , sql	0	2098	April 29, 2016
How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::addAttributeGrouping() work? database , eav , eav-collection , collection , db-group , sql , db-collection	0	1084	April 29, 2016
How does \Magento\Framework\Data\Collection\AbstractDb::getSize() work? collection , database , db-collection , db-count	0	1211	April 29, 2016
How does \Zend_Db_Select::reset() work? zend-framework-1 , zend-framework , db-select , database	0	4372	April 29, 2016
How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::getSelectCountSql() work? sql , db-count , collection , database , db-collection , eav , eav-collection , attribute , attribute-collection	0	1480	April 29, 2016
How does \Magento\Framework\Data\Collection\AbstractDb::getSelectCountSql() work? database , collection , db-collection , db-count	0	1422	April 29, 2016
How does \Zend_Db_Select::getPart() work? database , zend-framework , zend-framework-1 , db-select	0	1948	April 29, 2016
How does \Magento\Framework\Data\Collection\AbstractDb::_renderFilters() work? collection , db-collection , database , collection-filter	0	1075	April 29, 2016
How does \Magento\Framework\Data\Collection\AbstractDb::_renderFiltersBefore() work? database , collection , db-collection , collection-filter	0	1143	April 29, 2016
How does \Magento/Framework/DB/Transaction::_commitTransaction() work? database , db-transaction	0	937	April 26, 2016
How does \Magento/Framework/DB/Transaction::_startTransaction() work? db-transaction , database	0	1288	April 26, 2016
How does \Magento\Framework\EntityManager\Db\ReadRow::execute() work? entity-manager , eav , database , product-retrieving , product	1	878	April 25, 2016

How to execute the COUNT() SQL function

database , sql , db-count

2

13780

December 1, 2018

How to dump a store's database schema for convenient reading and comparison in tools like Araxis Merge?

mysql

1

718

November 10, 2018

How to decrypt a password from a store's configuration?

configuration , encryption

0

2248

November 7, 2018

How to get the database name programmatically

database

1

2977

March 13, 2018

How to get the MySQL server's version with PHP?

mysql , version

0

760

December 23, 2016

How to programmatically check whether a database table contains a specified column?

db-column , db-table , sql

1

1677

November 4, 2016

How to rename a database column?

db-alter-table , db-column , database , db-table , sql

1

2752

November 4, 2016

How to change (modify) a column definition for a database table

database , sql , db-table , db-alter-table , db-column

1

20596

January 26, 2016

How to programmatically execute the «SHOW TABLE STATUS» SQL statement for a database table

database , show-table-status , sql

1

2690

January 26, 2016

How to alter a database table?

database , sql , db-table , db-alter-table

1

3021

January 26, 2016

How to delete (drop) a foreign key from a database table

database , sql , db-table , db-alter-table , foreign-key

1

4768

January 26, 2016

How to add a foreign key to a database table

database , sql , db-table , db-alter-table , foreign-key

1

10890

January 26, 2016

How to delete (drop) an index from a database table

database , sql , db-table , db-alter-table , db-index

1

6958

January 26, 2016

How to add an index to a database table

database , sql , db-table , db-alter-table , db-index

1

11943

January 26, 2016

How to rename a database table

database , sql , db-table , db-alter-table

1

3193

January 26, 2016

How to delete (drop) a column from a database table?

database , sql , db-table , db-alter-table , db-column

2

6837

November 4, 2016

How to add a column to a database table?

database , sql , db-table , db-alter-table , db-column

2

10589

November 4, 2016

How does \Zend_Db_Select::group() work?

zend-framework , zend-framework-1 , db-select , database , db-group

0

1087

April 29, 2016

How does \Magento\Framework\DB\Adapter\Pdo\Mysql::getCheckSql() work?

database , sql

0

2098

April 29, 2016

How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::addAttributeGrouping() work?

database , eav , eav-collection , collection , db-group , sql , db-collection

0

1084

April 29, 2016

How does \Magento\Framework\Data\Collection\AbstractDb::getSize() work?

collection , database , db-collection , db-count

0

1211

April 29, 2016

How does \Zend_Db_Select::reset() work?

zend-framework-1 , zend-framework , db-select , database

0

4372

April 29, 2016

How does \Magento\Eav\Model\ResourceModel\Entity\Attribute\Collection::getSelectCountSql() work?

sql , db-count , collection , database , db-collection , eav , eav-collection , attribute , attribute-collection

0

1480

April 29, 2016

How does \Magento\Framework\Data\Collection\AbstractDb::getSelectCountSql() work?

database , collection , db-collection , db-count

0

1422

April 29, 2016

How does \Zend_Db_Select::getPart() work?

database , zend-framework , zend-framework-1 , db-select

0

1948

April 29, 2016

How does \Magento\Framework\Data\Collection\AbstractDb::_renderFilters() work?

collection , db-collection , database , collection-filter

0

1075

April 29, 2016

How does \Magento\Framework\Data\Collection\AbstractDb::_renderFiltersBefore() work?

database , collection , db-collection , collection-filter

0

1143

April 29, 2016

How does \Magento/Framework/DB/Transaction::_commitTransaction() work?

database , db-transaction

0

937

April 26, 2016

How does \Magento/Framework/DB/Transaction::_startTransaction() work?

db-transaction , database

0

1288

April 26, 2016

How does \Magento\Framework\EntityManager\Db\ReadRow::execute() work?

entity-manager , eav , database , product-retrieving , product

1

878

April 25, 2016

Development Database