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 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 [...]
[Read more...]How to Delete More Than 50 Tickets for Each Execution in osTicket v1.6 RC5
Sometimes, after the certain period you did some tests for your osTicket System, you have produced so many records in your ost_ticket table and want to remove all of them for each execution for the certain number of tickets. Let’s say you want to remove 100 tickets for each removing execution from the tickets list [...]
[Read more...]
Recent Comments