How to Handle Duplicate Records by Deleting and Leaving Only One Record from Each Duplicate Records in MySQL Database

Have you ever got difficulty when handling the duplicate records in a table in MySQL database, where you want to delete the records and pretty leaves one record from each duplicate records? This usually happens in the table who did not have the primary key, so that it can cause to store the duplicate records. [...]

Share
[Read more...]

How to Replace the Certain Character in a MySQL Table

Have you ever encountered the strange behavior while you were deleting the certain records from a table in MySQL database using an application you build, which those records cannot be deleted? Well, I have! Today, I encountered this problem. This is so weird, since I have never faced this situation before. Well, after doing some [...]

Share
[Read more...]

How to Remove Product ID from URL of PrestaShop version 1.2.5

Have you ever wanted to remove the product id from the URL of your PrestaShop? For instance, by default, PrestaShop uses this URL to display the certain product named ipod-touch: /7-ipod-touch.html instead of /ipod-touch.html. Well, here is the solution how you can make it comes true. I have successfully implemented it into PrestaShop version 1.2.5. [...]

Share
[Read more...]