communication nowadays: > My company phone fell into a reboot cycle. Do you have an idea? > Your phone has passed 2 years of age 9 days ago, you can have now a new phone.
As suggested in a comment already, you will have to create an intermediate table as the target of COPY, and then insert into the final table in the second step.
If you don't have to keep the intermediate table (for cross-checking your results, or as an easy retry point), you can make it temporar...
My query is following:
SELECT total_requests, author
FROM db.authors
LEFT JOIN db.user_data ON authors.author_id = user_data.id
WHERE (date > (now() - INTERVAL 30 MINUTE))
AND user_data.domain LIKE '%example.com%'
GROUP BY bidder;
It returns all results between now() and last 30 minutes, that'...