This article shows how you can create a new database table and install data into the table while installing a custom module or upgrading the module in Magento 2. The install and upgrade setup script file should be inside the Setup folder of your module. The install script should be named InstallSchema.php & InstallData.php and … Read more
This article shows SQL query to get size (in MB) of all MySQL databases. It also shows the query to get the size (in MB) of all the tables present in any particular database. Get size (in MB) of all MySQL databases SELECT table_schema "Database Name", sum( data_length + index_length ) / 1024 / 1024 … Read more
In my previous article (Magento: Very Useful Collection Functions), I had written about database interaction functions present in class Varien_Data_Collection_Db. Here, I am going to explain some database interaction functions present in the class Mage_Eav_Model_Entity_Collection_Abstract. These collection functions are very useful to select data from Magento database. We need them almost all the time for … Read more
The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables. [@via w3schools] A SQL JOIN clause combines records from two or more tables in a database. It creates a set that can be saved as a table or … Read more
Problem: I want to create a dynamic HTML table with a row starting after certain number of columns, i.e. like, i want to create an html table which automatically generate new row after 3 columns in a row. Solution: $content = array(1, 2, 3, 4, 5, 6, 7, 8, 9); <table border="1" width="50%"> <tr> <?php … Read more