Re: Inserting a MySQL select result not working? part 2
> | YLW | 2010 | 64788,64788,64788 | 3 | 3116.6667 |
Joining on year diff between 0 and 5 will include dupes. To exclude them, you need year diff between 1 and 5.
> Warning | 1260 | Row [some row no] was cut by GROUP_CONCAT()" |
Default group_concat_max_len is 1024, try setting it to something like 20480.
Subject
Written By
Posted
Re: Inserting a MySQL select result not working? part 2
October 25, 2017 02:33PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.