Get country name from country code in magento
When dealing with magento customization sometimes we need to get country name from country code. Its pretty easy to do so with a single line of code Magento has a model to manage the countries which is directory/country So first …
Calculate age in years months and days in mysql
When we are dealing with dates in mysql sometimes we need to calculate the age in years months and days directly from the mysql query We can easily achieve it from the below sql query And the output of the …
OpenID 2.0 for Google Accounts is going to Shutdown
Google OpenID 2.0 for Google Accounts is going to Shutdown and they are migrating Open ID 2.0 to the Google Plus Sign-In. Open ID 2.0 and Google Plus Sign-In is a way that allows website owners to let their users …
Import CSV File Into MySQL using LOAD DATA INFILE
In this post we are discussing on how to use LOAD DATA INFILE statement to import CSV file into MySQL table. The following statement imports data from c:\tmp\data.csv file into the discounts table. The field of the file is terminated …
