How to Create Breadcrumb Using the Nested Set Data Model in SQL Server

Still remember the similar article I wrote regarding the title of this article? Well, if you want to … [Read more...]

How to Create Breadcrumb Using the Nested Set Data Model in MySQL

There are so many articles in the Internet have explained us that the Nested Set Data Model has many … [Read more...]

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 … [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 … [Read more...]

How to Change Default Storage Engine When Creating New Table in Wampserver

Wampserver is one of the popular PHP-Apache-MySQL server for Windows operating system. If you want … [Read more...]

How to Know The Duplicate Records Based on The Same Value in a Field in MySQL Database

Have you ever wanted to know which record has duplicate content based on the same content in a field … [Read more...]