I have table that has well over a million entries and need a query to remove a lot of entries in one go. Every entry is linked to a specific thread. What I need to do is remove all those entries where the last entry in that thread was before a specific time. The query I use to identify those entries is as follows:
select thread FROM board group by thread HAVING MAX(addedon) <'1546300801'
I now need the mysql routine to delete all those entries associated with those threads.
20 freelanceria on tarjonnut keskimäärin 410£ tähän työhön
I have strong skills in Database Programming and can delete the queries you want in quick time . For further discussions let's talk over in chat
if you're looking for great web developer and designer i can help you cause i have a 3 years experience in web design and programming i am a new freelancer let this be my first job nice to work with you and thanks