Magento 1.9 – How to Get Database Table Names

magento-1.9

I need to add some checks on database all tables for this want to get all tables name which are exist in database.

Is there any way to get all tables name from database in magento1.9?

Best Answer

$connection = Mage::getModel('core/resource')->getConnection('core_read');
$sql = 'SELECT TABLE_NAME 
        FROM INFORMATION_SCHEMA.TABLES
        WHERE TABLE_TYPE = "BASE TABLE" AND TABLE_SCHEMA="magento1" '; //your db name
$names = $connection->fetchAll($sql);
Mage::log($names, null, "db.log");

Try this

Related Solutions

Magento – How add table name prefix to all table after Magento installation

The way I know is to use the following command either one by one:

RENAME TABLE tb1 TO my_prefix_tb1;

SELECT Concat('ALTER TABLE ', TABLE_NAME, ' RENAME TO my_prefix_', TABLE_NAME, ';') FROM information_schema.tables WHERE table_schema = 'my_database'

as described here

and then edit the app/etc/local.xml and find the tag with name <table_prefix> and update it accordingly <table_prefix><![CDATA[my_prefix_]]></table_prefix>, and save it.

You have to run these queries directly in the database so please please take a backup first or try on staging.

Magento 1.9 – How to Get Country ID from Country Name

You can use below code for that

$countryName = 'your country name';
$countryId = '';
$countryCollection = Mage::getModel('directory/country')->getCollection();
foreach ($countryCollection as $country) {
    if ($countryName == $country->getName()) {
        $countryId = $country->getCountryId();
        break;
    }
}
$countryCollection = null;
print_r($countryId);

Best Answer

Related Solutions

Magento – How add table name prefix to all table after Magento installation

Magento 1.9 – How to Get Country ID from Country Name

Related Topic