Using INSERT IGNORE and ON DUPLICATE KEY UPDATE With MySQL to Prevent Duplicate Key Issue

When you insert multiple rows in mysql database and want to skip duplicate entries. Otherwise you always get mysql failure message of duplicate key. To overcome this issue Mysql provide two type of Query for insert data. First one is INSERT IGNORE and other is ON DUPLICATE KEY UPDATE. Lets check it how we can … Read moreUsing INSERT IGNORE and ON DUPLICATE KEY UPDATE With MySQL to Prevent Duplicate Key Issue

How to Install Magento Security Patch via Putty

To install magento security patch using putty follow below given steps. Step 1: First download the security patch from this link https://www.magentocommerce.com/products/downloads/magento/. You can download the security patch after sign in magentocommerce account. Step 2: Under Release archive tab find the security patch as per your magento version. Make sure download the patch which match … Read moreHow to Install Magento Security Patch via Putty

How to Integrate Dwolla Payment Gateway in Website

Dwolla’s api provide the service to send money, request money, add bank accounts, retrieve transaction data and accept payment etc. To access Dwolla api you need to create a consumer application using this link https://www.dwolla.com/applications/create. After creating it you will get api key and secret for api access. You can use HTML code in your … Read moreHow to Integrate Dwolla Payment Gateway in Website