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. [...]
[Read more...]How to Handle Duplicate Records by Deleting and Leaving Only One Record from Each Duplicate Records in MySQL Database
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 in MySQL database? This information will be get after you select the records and display them which one have the same content by groupping them by that field. Well, here is the script how you can [...]
[Read more...]Record per Page Limit in Client My Ticket Page in osTicket v1.6 RC5
Today I made another modification into osTicket version 1.6 RC5. It was about the page limit or displaying the ticket list page based on the maximum record per page. I wanted the ability for client to choose and also to change how many records per page will be displayed in the My Ticket page. After [...]
[Read more...]
Recent Comments