Get customer by custom attribute in Magento
We can get customer by custom attribute in magento with a single line of code as shown below, Just pass the attribute name and the desired value In the above code username is the desired custom attribute and yourusernamehere is …
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 …
