Question : I have a MySQL master-slave replication setup. When I checked show slave status, I got the result as […]
Tag: duplication
Deleting duplicate based on latest datestamp entry
Question : I have a table and I’m trying to remove all the duplicate and keep the the rows that […]
Find duplicate records across one-to-many relationship tables
Question : Let’s say I have two tables that have a one-to-many relationship: People and Attributes. I’m trying to find […]
Is this data duplication when two exact pieces of data have different lifespans?
Question : In my system, user has many bank accounts stored in bank_accounts table. Each bank account has a currency […]
Preventing duplicate data when usual normalization only makes sense for some of the records
Question : Background I have two tables, one called issues and the other called status_checks, which both contain (among others) […]
merge like rows then update fk from another table to match the new values
Question : I have 2 tables tb1 (id, name, record_no, location,…) tb2(id, test, date,…) Tb1 is joined to tb2 on […]
Looking for help reporting duplicates and null marks
Question : Someone over at StackOverflow suggested this might be the place to ask this. I hope this will question […]
Merge two huge tables keeping only the unique rows
Question : I have two tables: table1 with 61 million rows and table2 with 59 millions rows. The columns in […]
Storing statistic results
Question : I’m doing a small database for statistics, it’s a really simple statistic like calculating the cost of an […]
Triggers that inserts values to a table from another table [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]